I cannot update data thru dataset&LINQ

  • Thread starter Thread starter Sergey Topychkanov
  • Start date Start date
S

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
 
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.
 
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
Click to expand...

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.
 
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
Click to expand...

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.
 
Back
Top