Is it possible with Linq to update a dataset?

[BlackSun]

Hi,
I have this working code which update a column:

For Each rigaFF As DataRow In Me.dtSizeA.Rows
For Each rigaTemp As DataRow In
Me.dtSizeB.Select(String.Concat("Name = ", CStr(rigaFF(0))))
rigaTemp(18) = rigaFF(3)
Next
Next

Is it possible to do the same with Linq?

Thanks in advance for your help!!!

Cheers, BlackSuna

 

[Cor Ligthert[MVP]]

AFAIK No.

if you want to use Linq for SQL Server (not other ones) have a look to Linq
to SQL or Linq to EF

It is easy with Linq to SQL, just add a Linq to SQL item and go than to
server explorer to select the tables like in AdoNet.

DataContext SubmitChanges does than the update.

(You can do normal Linq in a DataSet, but a dataset does not mean direct
AdoNet)

 

[Michel Posseth [MCP]]

Yes you can update a dataset with Linq , just set a value to the entity

HTH

Michel