p.DeptName.SelectAll()获取日期出错

[Tinyipfaan]

实体类：

namespace SqlSugarDemo
{
    /// <summary>
    /// 用户表
    /// </summary>
    [SugarTable("User")]
    public class User
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int UserId { get; set; }
        public string? Name { get; set; }
        public int Age { get; set; }
        public double Weight { get; set; }
        public DateTime CreatedDate { get; set; }
        public int DeptId { get; set; }
        public string DeptName { get; set; }
    }
}

namespace SqlSugarDemo
{
    [SugarTable("Department")]
    public class Department
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int DeptId { get; set; }
        public string? DeptName { get; set; }
        public double Number { get; set; }
    }
}

namespace SqlSugarDemo
{
    public class DefaultContext
    {
        public SqlSugarClient Client { get; }

        public DefaultContext(string connectionString, DbType dbType)
        {
            Client = new SqlSugarClient(new ConnectionConfig
            {
                ConnectionString = connectionString,//"Data Source=./demo.db",
                DbType = dbType,
                IsAutoCloseConnection = true,
                InitKeyType = InitKeyType.Attribute,
            });
            Client.CodeFirst.InitTables<User>();
            Client.CodeFirst.InitTables<Department>();
        }
    }
}

测试

public class Program
    {
        static void Main(string[] args)
        {
            var context = new DefaultContext("Data Source=./demo.db", DbType.Sqlite);
            //普通查询
            var dtos = context.Client.Queryable<User>()
                .Select(it => new UserDto
                {
                    UserId = it.UserId.SelectAll(),
                }).ToList();
            Console.WriteLine("查询成功");
            //左连接查询
            var depDto = context.Client.Queryable<User, Department>((it, p)
                => new JoinQueryInfos(
                    JoinType.Left, it.DeptId == p.DeptId
                ))
                .Select((it, p)
                => new UserDto
                {
                    DeptName = p.DeptName.SelectAll(),
                }).ToList();
            Console.WriteLine("查询成功");
        }    
    }

第一个查询数据库中日期字段默认值1900-01-01 00:00:00.000

第二个查询join之后映射成了0001...

[DotNetNext]

收到

[DotNetNext]

你这个就该是Left Join 右边表为空

[DotNetNext]

所以都是默认值了

[DotNetNext]

你LEFT JOIN右边是空所变成这样了 没有问题

[DotNetNext]

CreatedDate可以设置 DateTime? 这样就返回 null

[Tinyipfaan]

LEFT JOIN即使右边为空，也应该有数据。更何况Department表不为空，查询到是有数据的。是没取到数据，这应该是Bug吧。

[DotNetNext]

你这个代码写错了 , 这样才是对的

UserId =it.UserId.SelectAll() DeptName = p.DeptName,

[DotNetNext]

还有疑问吗？

[DotNetNext]

长时间未回复，先关闭，还有疑问发布新的issue