More and more, LINQ to SQL is being seen as a temporary solution. With the impending release of ADO.NET Entity Framework, a lot of people are worried that development on LINQ to SQL will fall by the wayside. With Microsoft's long history of developing and discarding database access technologies, these concerns are not without merit. So this raises the question, "Should LINQ to SQL Go Open Source?"
Roberto Zicari, from ODBMS.org, collected interviews and stories from several users of Object/Relational mapping technologies. The main point of the cases was around "impedance mismatch" between the object technology in the domain model and the relational technology in the data model.
The beta for Service Pack 1 of .NET 3.5/VS 2008 brings with is a host of new features and libraries including the ADO.NET Entity Framework and Data Services, a client-only version of the Framework, and changes to most of the 3.0 and 3.5 libraries. Despite its name, to many developers this release is as significant as 3.5 itself.
Beth Massi, the Visual Basic content manager on Microsoft's MSDN, presents on how to work with XML and LINQ in Visual Basic 9.
Besides the ubiquitous praise within the community, LINQ has quite a steep learning curve. Two tools, VLinq and LINQpad, try to help developers become more familiar with the LINQ syntax.
NHibernate 2.0 Alpha has been released this week. The current 2.0 release is the first step to the feature set of Hibernate 3.2.6, many classes have been completely rewritten and lots of features have been added.
Scott Hanselman recently posted a really useful article on his blog covering the NOLOCK hint when using LINQ to SQL and LINQ to Entities. The problem is actually how to get the SQL generated by LINQ queries to use the NOLOCK hint as SQL developers are accustomed.
Now that LINQ has been finalized and released, it is time to start thinking about the ways to use it. Keith Farmer even talks about using it eliminate subclasses. But before we get into that, let us take a look at the official guidance from Microsoft.
A new alpha version of the typesafe LINQ provider, LINQ to XSD, is available. This is the first version compatible with the RTM version of Visual Studio 2008.
Whether it's LISP macros or LINQ's expression trees - access to the AST of code is a powerful tool. We look at how ParseTree allows this in Ruby - and how it's being used in libraries like Ambition, Sequel and the web framework Merb.
Developers familiar with functional programming languages might not need an explanation as to why expression trees are useful. For the rest of us expression trees are the most striking concept of all the new features in C# 3.0 or VB 9.0.
SQLite is an open source database that has been growing in popularity. It's footprint is small and is used in a wide-variety of types of applications.
Floyd interviews Jimmy Nilsson on Microsoft's data access mechanism, LINQ to SQL.
For the most part LINQ works very much like SQL. Sources, joins, selects, and where clauses are all pretty standard fare. The Group/By/Into clause is where this breaks down. Unlike SQL, which always returns a rectangular dataset, LINQ is capable of returning hierarchical data. This brings new challenges of its own.
Eight vendors have are planning to release drivers for ADO.NET Entity Framework within three months of RTM. IBM, MySQL AB, and a host for 3rd party vendors are targeting databases such as DB2, MySQL, and Oracle.