How can write vb SQL insert code in linq
-
Hi all How can I use with linq command like this: INSERT INTO tablename1 (column1, column2, column3,...) SELECT (column4, column5, column6,...) FROM tablename2 I hop to be clear :| Thanes
-
Hi all How can I use with linq command like this: INSERT INTO tablename1 (column1, column2, column3,...) SELECT (column4, column5, column6,...) FROM tablename2 I hop to be clear :| Thanes
I think you could do something like this:
var SeletcToInsert = from tbl2 in tablename2
where ...
select new A
{
...
};tablename1.InsertAllOnSubmit(toInsert);
dc.SubmitChanges(); -
Hi all How can I use with linq command like this: INSERT INTO tablename1 (column1, column2, column3,...) SELECT (column4, column5, column6,...) FROM tablename2 I hop to be clear :| Thanes
:-O :rolleyes: :(( :sigh: :zzz: hi insert into tablename (seelct column4, column5, column6,.. from tablename1)