Subsonic 3.0 with timestamp field in SQL 2005

subsonic3timestamp

I have a timestamp field in a table and when i create a new instance of my object, set some fields, do not set the timestamp field and use the .Save(), i get an error saying that i cannot set an exlicite value to a timestamp field during an INSERT.

How can i have SubSonic not save anything in that perticular field?

Thank you

Best Answer

I'm not sure I perfectly understand the question, but the default SubSonic templates are set up to treat certain date/time fields as special cases, those being CreatedOn and ModifiedOn. You could look through your T4 template for references to those fields and modify their behavior.

Does this even apply to your situation, or are your timestamp fields named something else completely?

Related Solutions

Subsonic 3.0 and SqlHierachyID

Sprocs can be strongly-typed by calling ExecuteTypedList()

I would create an issue on the Github tracker to either add support for the type (someone will have to contribute this since I don't think it's a high priority) or to gracefully handle it when they exist.

Linq – Outer Joins with Subsonic 3.0

Getting back a collection of departments which each contain a collection of divisions would be ideal

SubSonic does this for you (if you setup your relationships correctly in the database), just select all Departments:

var depts = Model.Department.All();

There will be a property in each item of depts named Divisions, which contains a collection of Division objects.

Best Answer

Related Solutions

Subsonic 3.0 and SqlHierachyID

Linq – Outer Joins with Subsonic 3.0

Related Topic