LINQ AND THE ADO.NET ENTITY FRAMEWORK

 

Practical Tips

• Spend Time playing around with the anonymous types, looking at the different options that the intelligence list gives you.
• It is a good practice to try to filter data as much as possible, try to incorporate the Where clause.
• Make use of anonymoues type to decrease memory comsumption of your LINQ queries.

LINQ is a exciting Technology that ships with .NET 4 is an important techhique in many data-access scenarios including database access in ASP.NET web applications using EF(Entity Framework).
LINQ is so important an it has been integrated in many different places in .NET

 Additionally, LINQ is available for XML, Entities, ADO.NET and Data Sets, each tipy providing access to a different data source.

Practical Tips for Updating and Displaying Data

• Always store your connection in Web.config
• Consider Add validation controls to your data entries.
• If you have long lists of data to present, always consider turning paging on  for controls like GridView.
• Consider renaming your controls in the page to something other than their default values.

What is the different between BoundField and TemplateField?

A BoundField is directly tied to a column in your data source and offers only limited ways to customize its apperance. The TemplateField on the other hand, gives you full control over the way the field is rendered.

Coming up: LINQ AND THE ADO.NET ENTITY FRAMEWORK.