多表查询关联赋值 返回

SqlSugar 老数据
1 1276
该叫什么 若安 发布于2020/12/2
悬赏:5 飞吻

public class User

{

    public int ID{get;set;}

    public int CustomerId{get;set;}

    public int Name{get;set;}

    public int PassWord{get;set;}

}


public class Customer

{

    public int CustomerId{get;set;}

    public string CustomerName{get;set;}

    public string A{get;set;}

}

怎么快捷赋值 A表的所有字段

Select<User,Customer>((a,b)=>new Model{a.所有字段,b.CustomerName})

热忱回答1

  • 方法一:

    public class User

    {

        public int ID{get;set;}

        public int CustomerId{get;set;}

        public int Name{get;set;}

        public int PassWord{get;set;}

        [SugarColume(isIgnore=true)]

        public string CustomerName{get;set;}

    }

    .Select<User>()

    方法二:

    public class UserCustomer

    {

        public int ID{get;set;}

        public int CustomerId{get;set;}

        public int Name{get;set;}

        public int PassWord{get;set;}

        public string CustomerName{get;set;}

    }

    .Select<UserCustomer>()

    0 回复