-
Archives
- November 2010
- March 2010
- February 2010
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
Monthly Archives: January 2006
Fundamental Principles of Framework Design
I just finished reading chapter 2 of Framework Design Guidelines by Krzysztof Cwalina and Brad Adams that discusses Framework Design Fundamentals. Even though the chapter is only 26 pages long, it is filled with a lot of good advice on … Continue reading
Reasons Why Bulk-Copy is Faster
Kudos to Pablo Castro, the Program Manager for the ADO.NET Team at Microsoft, for explaining why SqlBulkCopy in ADO.NET 2.0 is faster than inserting records into a table. “There are a number of reasons why bulk-copy is faster. Here is a summary: … Continue reading
Posted in ADO.NET
Leave a comment
Programmatically Creating Stored Procedures with SQL Server Management Objects (SMO)
I mentioned awhile ago that I built a simple Database Explorer and Code Generator Tool as a pet project for use on my projects. It is not as flexible as CodeSmith, but I happen to like the interface much more for simple … Continue reading
Posted in Uncategorized
Leave a comment
OOP and Design Pattern Resources
I received an email message via this blog for some help in identifying good recources on OOP and Design Patterns for those new to the concepts. It has been awhile since I browsed the Internet for such resources and read … Continue reading
Posted in Design Patterns
7 Comments
Enterprise Library 2.0 DAAB and ADO.NET 2.0 Batch Updates Feature
ADO.NET 2.0 Batch Updates is a new feature that helps eliminate the number of roundtrips taken by the SqlDataAdapter when it issues commands against the database. Rather than the fixed one round trip per command in previous versions of ADO.NET, … Continue reading
Posted in Uncategorized
1 Comment
Enterprise Library 2.0 Data Access Application Block
The Enterprise Library 2.0 Data Access Application Block can help you with a lot of your data access plumbing in your .NET applications as well as provide a database agnostic solution for .NET applications that need to target multiple databases. … Continue reading
Posted in Application Blocks
5 Comments
Enterprise Library 2.0 – Hello IConfigurationSource
Enterprise Library 2.0 should be released sometime this month. The latest version, the Enterprise Library 2.0 December Interim Community Drop, is quite stable and reliable enough to start playing with now. I doubt there will be many, if any, changes between now … Continue reading
Posted in Application Blocks
2 Comments
MVP Award
I received very humbling news last night that I received an award as an MVP in C#. Thank you so much to those who nominated me and to those who felt I was worthy of the award. Congratulations to Geoff, … Continue reading
Posted in Uncategorized
7 Comments
Parameterized Queries and Performance
Parameterized queries can help you with injection attacks, but they can also help with performance as most databases will attempt to improve their performance by caching query plans. If you use string concatentation when forming queries as shown below, the database … Continue reading
Posted in ADO.NET
5 Comments