Assign value to String Property based on integer Property value in Linq query

Question

I have a linq query, and want to assign string value to a string property, which in dependent on another int property value. I have saved int value in database, and now want to get appropriate string value for the saved integer value. Below is my query..

 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();

I got below error

The entity or complex type 'PMISModel.ProjectSetup' cannot be constructed in a LINQ to Entities query

You cannot do that onto a mapped entity.Check this,stackoverflow.com/questions/5325797/… — Sajeetharan
– Sajeetharan, Commented Dec 2, 2014 at 6:01

Shahid Iqbal · Accepted Answer · 2014-12-02 06:15:22Z

2

 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();

answered Dec 2, 2014 at 6:15

Shahid Iqbal

2,1339 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Enigmativity Over a year ago

You probably should point out that you added .ToList(); and why you did so.

Collectives™ on Stack Overflow

Assign value to String Property based on integer Property value in Linq query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related