The application I am currently working on uses Microsoft Enterprise Library Data Access block for Data Access.
I have pasted the following method to provide context:
public static DataSet ExecuteDataSet(string connection, string procName)
DataSet ds = null;
SqlDatabase db = new SqlDatabase(connection);
DbCommand dbCommand = db.GetStoredProcCommand(procName);
ds = db.ExecuteDataSet(dbCommand);
catch (Exception ex)
//Exception handling code
In the next release we are planning to use SQL Server 2008 R2 as our database and we will be implementing mirroring to provide automatic failover.
I have been tasked with rewriting the DAL to take advantage of this.
A sample connection string used by the application today is as below:
View Complete Post