If you are a .NET fan out there then you will basically hearing from many people asking, I have ADO.NET 2.0 so why is there a LINQ? It was a myth to me too. After Microsoft launch Service Pack 1 for Visual Studio 2008 then I clear some of my cloud in my head.
I will only mention one of the unique features here, ADO.NET Entity Data Model from ADO.NET Entity Framework. I have not found a better way to bind the Entity Model to DataGridView web control.
In order to create ADO.NET Entity Data Model, right click either Windows Application Project or Web Application Project and choose Add New Item… . Select ADO.NET Entity Data Model from the Add New Item dialog. After that you will have a file with edmx extension.
I have created a complete Windows Application sample using Northwind database in MS SQL 2008 Express. The Entity named NorthwindEntities. The entire sample consisted of 2 controls, 1 DataGridView and another is Button. I only have few lines of code in Button click event as below.
private void btnGetCustomers_Click(object sender, EventArgs e)
NorthwindEntities nwe = new NorthwindEntities();
var cus = from customer in nwe.Customers
dataGridView1.DataSource = cus;
I guess no one will ever say this is difficult.
The complete code is in http://skydrive.live.com. The sample file name is WinAppEntities.rar. My MSN ID is email@example.com.