make Linq to Sql compiled queries for insert and update

Question

I am making select compiled queries as shown Here

but my question is how to make compiled queries for Insert and Update?

mine Insert query is

DataClassesDataContext db = new DataClassesDataContext();
tbl_desc_index tabledesc = new tbl_desc_index();
tabledesc.ed_journal_id = Convert.ToInt32(Server.HtmlEncode(Request.Cookies["j_id"].Value));
tabledesc.editor_id = Convert.ToInt32(Server.HtmlEncode(Request.Cookies["editorid"].Value));
tabledesc.short_desc = ck1.Text;
tabledesc.abt_journal = ck2.Text;
tabledesc.aim_scope = ck3.Text;
tabledesc.indexed_in = ck4.Text;
db.tbl_desc_indexes.InsertOnSubmit(tabledesc);
db.SubmitChanges();

Update query is

 DataClassesDataContext db = new DataClassesDataContext();
 var update = db.tbl_desc_indexes.First(p => p.ed_journal_id == Convert.ToInt32(Server.HtmlEncode(Request.Cookies["j_id"].Value)) && p.editor_id == Convert.ToInt32(Server.HtmlEncode(Request.Cookies["editorid"].Value))); 
 update.short_desc = ck1.Text;
 update.abt_journal = ck2.Text;
 update.aim_scope = ck3.Text;
 update.indexed_in = ck4.Text;             
 db.SubmitChanges();

its not duplicated....as i dont know how to make compiled queries for insert and update — , Dec 18 '13 at 09:56
@James sorry my mistake....I have found my answer from duplicated question — , Dec 18 '13 at 10:00
As a note on the side, what is the purpose of those `Server.HtmlEncode` calls? They don't make no sense to me. They cetainly don't do anything usefull in the case those cookies contain integers, nor in the case they don't. Or am I missing something? — Kris Vandermotten, Dec 18 '13 at 10:17

score 2 · Accepted Answer · answered Dec 18 '13 at 10:00

2

What part of the code would you want to speed up? The first seven lines have nothing to do with Linq per se. Line 8, db.tbl_desc_indexes.InsertOnSubmit(tabledesc); is merely passing a reference.

The statement that does all the hard work is

db.SubmitChanges();

That essentially does two things: find out what inserts and updates should be sent to the database, and send them. Generating the actual statements, part of the second step, is very efficient, especially for insert statments. In the case of update statements, the generation is more complex (i.e. has some overhead), because it generates different update statements depending on which columns got updated, but that results is more efficient network usage and often faster execution by SQL Server.

The only thing you can do, is create stored procedures for insert and update (and delete), tailored to your specific needs. There is no guarantee those would be faster though, but you can try and measure.

That being said, in some situations you can have very significant performance gains, by doing set operations for update or delete, i.e. updating or deleting more that one row at a time. Stored procedures are the way to go then.

answered Dec 18 '13 at 10:00

Kris Vandermotten

10,111
38
49

ok i more question is there – Dec 18 '13 at 10:04
my select query is var rr = editordetail1(db,1,2); It means i wanna pass 2 integer in compiledquery than how should i made my compiled query....?...public static Func> editordetail1 = CompiledQuery.Compile((DataClassesDataContext db, int a) => from p1 in db.editor_j_infs where p1.ed_journal_id == a orderby p1.editor_id descending select p1); //Its my precompile process – Dec 18 '13 at 10:07
@Xtremcool if that last remark is a new question, than ask it as a question, not a comment to an answer to this question. – Kris Vandermotten Dec 18 '13 at 10:11
ok i am asking new question – Dec 18 '13 at 10:12
have a look on http://stackoverflow.com/questions/20655383/make-compiled-queries-while-sending-2-int – Dec 18 '13 at 10:21

make Linq to Sql compiled queries for insert and update

1 Answers1