Submitchanges not updating
this._Walking = value; All I had to do was change this to this.
I worked out how to get LINQ to send the current datetime when I'm inserting new records (I just set the Auto Generated value = TRUE for the field in my dbml file and then in the database provide a default value for the table GETDATE() and that seems to work)However, that only works because LINQ just passed back NULL and the database server handles the rest. less than ideal, but secondly that doesn't do me any good for updates.I have a field Last Updated that needs to display the current datetime of the SQL server when the update is performed. I will also need to handle Last Updated By which would be the user name.From SQL server I can pull their server login, but that won't realy work for ASP.When I tried to put some break point in it, I got this error message which doesn't show on normal mode : System. In Use is a bit field) For some reason it isn't working. It's as if the The table could not be updated properly because it had no primary key.