根据 Linq 查询中的整数属性值为字符串属性赋值

本文关键字：属性 字符串 赋值 整数 Linq 查询 根据 | 更新日期: 2023-09-27 18:32:40

>我有一个linq query，并希望将字符串值分配给字符串属性，该字符串属性依赖于另一个int属性值。我已经在数据库中保存了 int 值，现在想为保存的整数值获取适当的字符串值。以下是我的查询..

 var data = db.ProjectSetups.Select(c => new ProjectSetup
                {
                    ProjectId = c.ProjectId,
                    Name = c.Name,
                    NameArabic = c.NameArabic,
                    StartDate = c.StartDate,
                    EndDate = c.EndDate,
                    Date = c.Date,
                    StringType = (c.Type.ToInt32() == 1 ? "Development" : "Rental").ToString(),
                    StringStatus = (c.Status == 1 ? "InProgress" :
                    c.Status == 2 ? "Completed" :
                    c.Status == 3 ? "Dividend" : "Closed"),
                    LandArea = c.LandArea,
                    SaleAmount = c.SaleAmount
                }).ToList();

我得到以下错误

实体或复杂类型"PMISModel.ProjectSetup"不能在 LINQ to Entities 查询中构造

根据 Linq 查询中的整数属性值为字符串属性赋值

 var data = db.ProjectSetups.ToList();
     data = data.Select(c => new ProjectSetup
                        {
                            ProjectId = c.ProjectId,
                            Name = c.Name,
                            NameArabic = c.NameArabic,
                            StartDate = c.StartDate,
                            EndDate = c.EndDate,
                            Date = c.Date,
                            StringType = (c.Type.ToInt32() == 1 ? "Development" : "Rental").ToString(),
                            StringStatus = (c.Status == 1 ? "InProgress" :
                            c.Status == 2 ? "Completed" :
                            c.Status == 3 ? "Dividend" : "Closed"),
                            LandArea = c.LandArea,
                            SaleAmount = c.SaleAmount
                        }).ToList();
相关文章：