Geeks With Blogs
Title Of Blog April 2012 Entries
Deleting a row from self-referencing table
Came across this the other day and thought “this would be a great interview question!” I’d created a table with a self-referencing foreign key. The application was calling a stored procedure I’d created to delete a row which caused but of course…a foreign key exception. You may say “why not just use a the cascade delete option?” Good question, easy answer. With a typical foreign key relationship between different tables which would work. However, even SQL Server cannot do a cascade delete of a row ......

Posted On Wednesday, April 11, 2012 10:02 AM

Auto-hydrate your objects with ADO.NET
Recently while writing the monotonous code for pulling data out of a DataReader to hydrate some objects in an application I suddenly wondered "is this really necessary?" You've probably asked yourself the same question, and many of you have: - Used a code generator - Used a ORM such as Entity Framework - Wrote the code anyway because you like busy work In most of the cases I've dealt with when making a call to a stored procedure the column names match up with the properties of the object I am hydrating. ......

Posted On Wednesday, April 11, 2012 9:50 AM

Copyright © Jake Rutherford | Powered by: