Tech-Review.Org

Having spent a good two hours troubleshooting the :   An attempt to attach an auto-named database for file D:\Sites-Easy\Web\App_Data\LocalRepository.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception ...

I'll state this upfront, this is not tested in terms of performance - as the objective with my DAL aproach is to reduce the number of methods the DAL contains and institute transactions for any data written to the database.  Additionally, utilizing Generics to tackle how to insert multiple batch statements that can automatically determine if ...

As of late I have been knee deep in both C# and SQL performance optimizations and tuning.  From the C# side of the client's application, I was able to make enough improvements that the application ran incredibly stable at 99% cpu utilization; however, the ability to determine the actual extent the coding changes would add to performance (if ...

I have been looking for methods to get rid of redundant code throughout my Sites-Easy Project.  The biggest issue I have is the redundancy of all of the DAL methods.  For instance I have the ability to add a Section that contains 40 some parameters, but also create methods to only update subsets of the Section Data.  While I can ...