Browse by Tags
All Tags »
SQL (RSS)
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
Read More...
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
Read More...
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,
Read More...
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
Read More...