To make C# works with SQL Server is one of the most difficult subject in software development. The good news is, .NET Framework creator provided bells and whistles to make programmers’ life easier. The DataGridView is a good example. It make interaction with SQL Server a bliss. Learning to use DGV can be challenge. But once you master it, the world is your oyster.
This Scenario presents Tips and Tricks of using the SQL Server 2008 database in your application. Learn how to work with LINQ to SQL. Overcome the incompatible of type system between SQL and C# by wrapping the database objects into C# Object using Microsoft Visual Studio 2008 build in Object-Relation Mapping tool (O/RM). Mastering the O/RM allow you to code database interaction in full OOP paradigm. This Scenario also covers several useful DGV techniques.