dotnetcore / dotnetcore/FreeSql

使用3.5.212版本,连接mdb数据库,查询表记录时,报错:“无效的null”使用

Open
#2,097 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

#### 问题描述及重现代码:
访问mdb库,当库中字段不填写任何内容时,访问报错:“无效的null”使用
使用代码 _freesql.select<实体类>().Tolist();
1.尝试实体类中隐藏该空列属性,正常。
2.该问题出现在字段同步时,禁用字段同步,只查询正常。
3.问题点应该在于框架对mdb数据表进行字段同步,出现string类型的字段且表中该字段值为默认空值时,会报此错误。

#### 数据库版本
.mdb(97-2003)格式

#### 安装的Nuget包
3.5.212

#### .net framework/. net core? 及具体版本
.net framework

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the issue with the reported .mdb 97-2003 database, FreeSql 3.5.212, and .NET Framework using _freesql.select().ToList(). Start by tracing the field-synchronization path for string columns containing default empty values. Done means the query no longer reports “无效的null” while field synchronization remains enabled.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.