Geeks With Blogs

Scott Kuhl Warning: I may have no idea what I am talking about!

It is possible to issue insert, update and delete commands through the query object by setting the QueryType property.  (Your options are Delete, Insert, Select, Update).

query.QueryType = SubSonic.QueryType.Insert;

If you want to add a specific update setting, such as setting all records to a specific value, you can use the AddUpdateSetting method, which can be called multiple times.

query.AddUpdateSetting(Product.Columns.UnitsInStock, 100);

Find the entire series of posts here.

Posted on Thursday, December 7, 2006 1:23 PM SubSonic | Back to top


Comments on this post: Getting Started with SubSonic - Part 17, Queries - Updating and Deleting

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Scott Kuhl | Powered by: GeeksWithBlogs.net