Hi,

Im using Linq to Update Record like this:

public bool update(string name)   
        {   
            try  
            {   
                var query = from Album in db.Albums   
                            where Album.id == id   
                            select Album;   
  
                foreach (Album Al in query)   
                {   
                    Al.name = name;   
                }   
                db.SubmitChanges();   
  
                return true;   
            }   
            catch  
            {   
                return false;   
            }   
        }  

After I updated the name,

Im getting the Data again

and I get the Old Name, not the New Name.

What I do Wrong?

Thanks...

Hi gb_007,

Sorry for the misunderstanding. I made a test project and met the same issue. The root cause I found is that the table has no primary key. I add a primary key and the data is updated successfully. You can add a primary key to the table in database and recreate the .dbml file to see if it works.

Let me know if this helps.
Aland Li

Hi,

Im using Linq to Update Record like this:

public bool update(string name)   
        {   
            try  
            {   
                var query = from Album in db.Albums   
                            where Album.id == id   
                            select Album;   
  
                foreach (Album Al in query)   
                {   
                    Al.name = name;   
                }   
                db.SubmitChanges();   
  
                return true;   
            }   
            catch  
            {   
                return false;   
            }   
        }  

After I updated the name,

Im getting the Data again

and I get the Old Name, not the New Name.

What I do Wrong?

Thanks...

Try it,

It still return me the Old Name.

When I Get it after Updating like u said.

WHAT TO DO?

Thanks..

I might have made a mistake in syntax, since I was doing this from memory and not behind VS at the time.Can you try this before we continue?

var album = (from a in db.Albums
where a.id == id
select a).FirstOrDefault();
album.name = name;
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}

Sure,

I set with it a ListView of Items.
With the albums name that I get from the DB.

Hi gb_007,

You need to use DataAdapter to update the data to database. This is a similar thread:
http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thread/51dbe4c1-41eb-442f-8a74-89b37db03405.

This is a sample discusses the common operations via Linq to Sql:
http://www.codeproject.com/KB/linq/LINQToSQLBaseCRUDClass.aspx.

You can get more information about DataAdapter from:
http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx.

You can get more information about Linq to Sql from:
http://msdn.microsoft.com/en-us/library/bb425822.aspx.

RefreshMode.OverwriteCurrentValues, db.Albums);
db.SubmitChanges();

It updates in DB.

But next Time I asked the same Album Name from DB,
I get the OLD name.

That's my problem.
Got it?

What to do?
Thanks..

Hi gb_007,

Sorry for the misunderstanding. I made a test project and met the same issue. The root cause I found is that the table has no primary key. I add a primary key and the data is updated successfully. You can add a primary key to the table in database and recreate the .dbml file to see if it works.

Let me know if this helps.
Aland Li