I began using Visual Studio Database Edition today, I did not used it before because I’m the only one in the team that have this edition, others developers used VS professional, but I’m the one who cares of database in this project, quite all modifications are done by myself, so I decided to create a [...]
Continue reading about Visual Studio Database Edition, First steps
Sometimes I need to generate insert statement, taking data from a starting database. Suppose you need to create sql installation scripts to create a database from scratch, quite often you need also to insert some initial data into some tables.
Sql server management studio does not provide a simple way to take a table and script [...]
Continue reading about Generate insert data for sql server tables
If you need to test drive with a database you can find a lot of problems. The basics of test drive with database is using a database sandbox, and creating a series of scripts that takes the database in a well known state before the run of each test.
In my projects I use NHibernate [...]
This morning I see from a server log this frightening error.. “The server encountered a stack overflow during compile time”. Fortunately I used elmah to log all error of the site, so I immediately find the page that gives that problem.
It turns out that in a page we used to make some query to get [...]
Continue reading about SqlError "The server encountered a stack overflow during compile time."
DisposableAction pattern is one of the most useful I , I used it to manage transaction for a DataAccess helper. I begin a transaction with DataAccess.BeginTransaction() that returns an IDisposable object that automatically dispose the tranasction. Here is an example of a typical use
using (DataAccess.BeginTransaction())
{
//Do whatever query you want with [...]
Continue reading about detecting if finally block is executing for an manhandled exception