Is there any simple way to implement the merge query of SQL Server in Linq?

Asked Feb 15 '12 at 18:36

Active Feb 15 '12 at 20:07

Viewed 683 times

1

Is there any simple way to implement the merge query of SQL Server in Linq?

Thanks in advance!

edited Feb 15 '12 at 19:11

marc_s

732,580
175
1,330
1,459

asked Feb 15 '12 at 18:36

zs2020

53,766
29
154
219

Could you add a concrete example of a query you'd like to rewrite? – Joachim Isaksson Feb 15 '12 at 18:39
Are you looking for the Union method? http://msdn.microsoft.com/en-us/library/system.linq.enumerable.union.aspx – rsbarro Feb 15 '12 at 19:02
@rsbarro Nope. Just the Merge command in MSSQL. – zs2020 Feb 15 '12 at 19:20

1 Answers1

0

There is no such built in functionality because the basis of LINQ is to query object models. However, it's not too hard to build it.

MERGE in Entity Framework (this example uses the Entity Framework)
http://msdn.microsoft.com/en-us/library/wkk7s5zk.aspx (this is an example of how it can be done using the ADO.NET DataTable -- interestingly enough this is a pretty good example from Microsoft)

edited May 23 '17 at 11:48

Community

1
1

answered Feb 15 '12 at 20:07

Mike Perrenoud

66,820
29
157
232