If you encounter a deadlock problem this resources can help to understand and solve the problem. Deadlocking http://msdn.microsoft.com/en-us/library/ms177433.aspx Minimizing Deadlocks http://msdn.microsoft.com/en-us/library/ms191242.aspx Detecting and Ending Deadlocks http://msdn.microsoft.com/en-us/library/ms178104.aspx
Timespan and Databases
When you are developing application you may need to store timespan database. (Assuming you are using Sql Server 2005) TimeSpan.TotalSeconds can be used to store. This returns a double. And maps to decimal data type of the sql server. For reverse action to get the time span you can use TimeSpan.FromSeconds method. This will give […]