i have the exception DBConcurrencyException i have two tables of the same schema and relations is on any of them one of them is of name Services and the other is Renters. The Services table does not have any problems in updating and deleting. but the Renters table throws the exception while updating and deleting.

The 2 tables has the same columns in data types of the columns and everything is the same except the table name. another thing, i tried the both tables in new application but the same exception is still exists.

Why ??

Hi ahmedashal,

Can you please provide some more details, like SQL Statements, Stored Proc, or .Net front end statements.

and table defenitions, so i can provide code for that.

Normally you can use CONVERT() function of SQL Server, to convertvalue to any SQL DataType. so you might solve your problem by using that,

If you need more help, let me know. i will send you code.

Thank You,

Best Regards

Utkarsh Gajjar.