Linq To Sql Issues :(

[Pino]

Ok, I'm using SQL Server Express 2008 and .Net 3.5 (c#)

I have a couple of datetime fields in the database and am trying to make an edit to a row (Using Linq-to-Sql) I receive the error "Row not found or changed."

I have spent some time getting the generated SQL and it seems that the issue is caused by the milliseconds attached to the datetime.

Generated SQL that does not work,

 @p5: Input DateTime (Size = 0; Prec = 0; Scale = 0) [20/10/2009 16:04:45]
 @p6: Input DateTime (Size = 0; Prec = 0; Scale = 0) [23/10/2009 10:15:36]
 @p7: Input DateTime (Size = 0; Prec = 0; Scale = 0) [23/10/2009 09:27:27]

AND ([SignUpDate] = @p5) 
AND ([LastActivityDate] = @p6) 
AND ([LastLoginDate] = @p7)

if i modify it myself like so it works,

 @p5: Input DateTime (Size = 0; Prec = 0; Scale = 0) [20/10/2009 16:04:45.390]
 @p6: Input DateTime (Size = 0; Prec = 0; Scale = 0) [23/10/2009 10:15:36.733]
 @p7: Input DateTime (Size = 0; Prec = 0; Scale = 0) [23/10/2009 09:27:27.747]

AND ([SignUpDate] = @p5) 
AND ([LastActivityDate] = @p6) 
AND ([LastLoginDate] = @p7)

What are my options in ways to get arround this?

Just to add this is my edit code,

var UserToEdit = this.GetUser(UserId);

UserToEdit.Forename = Fields["Forename"];
UserToEdit.Surname = Fields["Surname"];
UserToEdit.DateOfBirth = Convert.ToDateTime(Fields["DateOfBirth"]);
UserToEdit.DisplayName = Fields["DisplayName"];
UserToEdit.TelephoneNumber = Fields["TelephoneNumber"];

_db.SubmitChanges();

[gep13]

Hey,

What is the Data Type of that column in the Database?

Gary

[Pino]

DateTime

See this link,

http://stackoverflow.com/questions/8...und-or-changed

> # High precision datetime fields are used. The solution is to set
> UpdateCheck to never for that column
> your DBML file

This has resolved my issue but feel a bit like a hack.

I'm leaving this open to see what others think.

[Pradeep1210]

[20/10/2009 16:04:45] and [20/10/2009 16:04:45.390] are not equal dates. They differ by milliseconds. So when you do a compare ([SignUpDate] = @p5), you end up with no rows returned. So while comparing, you would either have to truncate the milliseconds part, or add the milliseconds part to the other so that they compare equal. I think the truncate approach would be easier than the add approach.

[Pino]

[20/10/2009 16:04:45] and [20/10/2009 16:04:45.390] are not equal dates. They differ by milliseconds. So when you do a compare ([SignUpDate] = @p5), you end up with no rows returned. So while comparing, you would either have to truncate the milliseconds part, or add the milliseconds part to the other so that they compare equal. I think the truncate approach would be easier than the add approach.

Yes exactly. However I cant edit the Generated SQL as i'm using the Generated Object and methods. I can only see the SQL because I have used the DatabseContexts Log property.

Here is the actual code as in the first post,

var UserToEdit = this.GetUser(UserId);

UserToEdit.Forename = Fields["Forename"];
UserToEdit.Surname = Fields["Surname"];
UserToEdit.DateOfBirth = Convert.ToDateTime(Fields["DateOfBirth"]);
UserToEdit.DisplayName = Fields["DisplayName"];
UserToEdit.TelephoneNumber = Fields["TelephoneNumber"];

_db.SubmitChanges();

Pino.

[gep13]

Hey,

Agreed, it seems like a bit of a hack, but I am not aware of anything else to get round it.

Gary