• timwell - Monday, April 16, 2018 9:54 AM

    Here is my list of other topics I have thought of for other articles on working with SQL Server in .Net

    Data sets and representation of relationships and constraints in .Net code (The first draft of this article is almost ready for submission.)
    Data types and what they convert to when you query SQL Server from .Net
    Different ways of doing the data conversion 
    Techniques for converting data for display etc.
    Dealing with nulls in data
    How to avoid SQL injection in your .Net web app
    Connecting LINQ to SQL Server
    Dealing with concurrency
    Catching data exceptions
    Debugging
    Working with Schemas in .Net

    I am interested in hearing any other ideas, and also the issues that might be helpful for developers (or DBAs) working with SQL Server data in .Net to know about.

    Great info, but when using objects that are disposable, you should use a using statement, so the connection or command are automatically closed and disposed. Alleviates code in the catch block