I cannot update data thru dataset&LINQ

[Sergey Topychkanov]

I have SQL SERVER 2008 Express and C# Express 2008 - both sp1.
I can remove and update data in my database only thru direct SQL query thru
database explorer,
but quite unable to do it through dataset and linq.
Thanks in advance
Sergey

 

[Nicholas Paldino [.NET/C# MVP]]

Sergey,

Well, what flavor of LINQ are you using? If you are just using LINQ and
updating DataSets, then you have to push the changed DataSet back to a
DataAdapter in order to persist the changes back to the DB.

Or are you using LINQ to SQL? It doesn't sound like you are.

 

[Kuma]

I have SQL SERVER 2008 Express and C# Express 2008 - both sp1.
I can remove and update data in my database only thru direct SQL query thru
database explorer,
but quite unable to do it through dataset and linq.
Thanks in advance
Sergey

If you are modifying the dataset by using linq to object you'll have
to commit the dataset's changes back to the database. If you use LINQ
to sql you won't have this problem.

 

[Sergey Topychkanov]

I think it's something with my SQL Server 2008 Express configuration.
Thanks in advance,
Sergey.

"Kuma" <[email protected]> Ñообщил/Ñообщила в новоÑÑ‚ÑÑ… Ñледующее:

I have SQL SERVER 2008 Express and C# Express 2008 - both sp1.
I can remove and update data in my database only thru direct SQL query
thru
database explorer,
but quite unable to do it through dataset and linq.
Thanks in advance
Sergey

If you are modifying the dataset by using linq to object you'll have
to commit the dataset's changes back to the database. If you use LINQ
to sql you won't have this problem.