How to assign one object to another in Linq c# without making new

Question

I'm facing an issue in assigning one object to another in Linq to SQL. In this example:

Func<result, result> make = q => new result
{
    Id = q.Id,
    lName = q.lName,
    GroupId = q.GroupId,
    Age = (from tags in q.age where tags.Del == null && tags.lId == q.Id select age).ToEntitySet(),

};

p = (from q in dc.results
        where q.Id == Id.Value
        select make(q)).First();

I am making new and assigning the object, but I don't want to do this, it will cause problem in insertion. I want to assign without making a new object, how is this possible?

Why make new `result` objects while the query (`dc.results`) already produces them? — Gert Arnold, Oct 26 '12 at 09:51

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

Jon Skeet and Marc Gravell have a library called MiscUtil. Inside MiscUtil.Reflection there is a class called PropertyCopy that does exactly what you describe. It only works for .NET 3.5.

It works by running over the public properties of the SourceType, matches them up by name with the public properties of the TargetType, makes sure that each property can be assigned from the source to the target and then creates and caches a copier function for those two types (so you don't do all this reflection every time). I've used it in production code and can vouch for its goodness.

Check this post out for a code example.

edited May 23 '17 at 12:27

Community

1
1

answered Oct 26 '12 at 05:00

gotnull

26,454
22
137
203

so without this there is no support from microsoft? – Naruto Oct 26 '12 at 05:06
i mean, if i do like this and call insertonsubmit() i get exception, duplicate key present, with this we can avoide? – Naruto Oct 26 '12 at 05:12

How to assign one object to another in Linq c# without making new

1 Answers1