Introducing LINQ
by Cecille Ramirez on April 21st, 2010Several years back, the only technology Microsoft developers use to work with database is ADO. Microsoft has a new baby that comes with their Visual Studio called LINQ.
LINQ stands for Language Integrated Query. The idea of LINQ is to address database development in the context of Object Oriented Programming development model. LINQ has a great power of querying relational, object and XML data. Microsoft categorizes it into three parts.
1.LINQ to Object (those that are in-memory cache)
2.LINQ to ADO .NET (relational)
3.LINQ to XML (xml source)
If you know SQL querying, LINQ will be easy to learn. Below are the nicest things with LINQ:
1.No more CRUD development since you are guided as you type your code thru the Visual Studio intellisense
2.No more grueling hunt for object name change like table name references by the LINQ code
since build errors can be easily followed and corrected thru debugging
LINQ as a whole is exciting and an entirely new technology which I truly believe has good potential and will be around for a long time just like the ADO. Both of these technologies will be the platform for database development in the .NET platform.
LINQ is included in the Visual Studio 2008 with codename ORCAS. There are virtual images that have ORCAS in it to sample your first LINQ programming. Check out the Microsoft website for more details where to download it. It should be “Visual Studio Orcas”!