Upsert a list with Simple.Data

Question

Trying to do a:

var list = new List<MyType>();
list.Add(new MyType() { PK1 = 1, PK2 = 2 });
list.Add(new MyType() { PK1 = 1, PK2 = 3 });
Database.Open().MySchema.MyTable.Upsert(list);

Nothing seems to happen, do i need to do a foreach or can i achieve this some how?

you aren't closing your brackets with your object initializer — Jonesopolis, Jun 18 '13 at 13:50
That should work, see https://github.com/markrendle/Simple.Data/blob/master/Simple.Data.SqlTest/UpsertTests.cs#L94 for example from test suite. Which back-end DB are you using? — Mark Rendle, Jun 18 '13 at 16:11
Thanks, read @jakobras answer. Needed to do a .ToArray() to make it execute! — Lars Stenberg, Jun 19 '13 at 08:57

score 5 · Accepted Answer · edited Sep 18 '16 at 21:04

5

This will work, or any other enumeration of the result.

Database.Open().MySchema.MyTable.Upsert(list).ToArray();

Although it will not generate a batch SQL query, there will be a lot of queries to the database, at least for SQL Server.

edited Sep 18 '16 at 21:04

marc_s

732,580
175
1,330
1,459

answered Jun 19 '13 at 08:55

Jakob Rasmussen

171
1
5

2

One of the headline features for Simple.Data 2 is batch operations. – Mark Rendle Jun 23 '13 at 21:54

Sam Leach · Answer 2 · 2013-06-18T14:22:57.347

1

Does

Database.Open().MySchema.MyTable.Upsert( new MyType { PK1 = 1, PK2 = 2 } );

work?

ToArray() -

var list = new List<MyType>();
list.Add(new MyType() { PK1 = 1, PK2 = 2 });
list.Add(new MyType() { PK1 = 1, PK2 = 3 });
Database.Open().MySchema.MyTable.Upsert(list.ToArray());

edited Jun 18 '13 at 14:22

answered Jun 18 '13 at 13:53

Sam Leach

12,746
9
45
73

Yes, that works but the point of the question is todo a batch. Not one at a time. – Lars Stenberg Jun 18 '13 at 14:14
1

Look at the documentation. Can you Upsert a list? – Sam Leach Jun 18 '13 at 14:21
Try ToArray() from a quick look at the documentation. – Sam Leach Jun 18 '13 at 14:25
What documentation do you look at, in the documentation at simplefx only upsert only says forthcoming? Anyhow, does not seem to work. – Lars Stenberg Jun 18 '13 at 14:32
Everything is on GitHub. https://github.com/markrendle/Simple.Data Look through the code. – Sam Leach Jun 18 '13 at 15:14
Did that, and it seems like a simple array will not work. Its a cast to a dictionary. – Lars Stenberg Jun 19 '13 at 07:41
The ToArray() needed to be outside the Upsert(x).ToArray(), thanks =) – Lars Stenberg Jun 19 '13 at 08:59
Looking at the documentation and looking at the code are not the same thing. It is helpful if you make this distinction as it saves people looking in the wrong place like Lars and myself were. Still, grateful for the pointer. – RyanfaeScotland Mar 19 '15 at 10:11

Upsert a list with Simple.Data

2 Answers2