Introduction
DbLinq is the "linq to SQL" for other databases. It currently supports MySQL, PostgreSQL, Oracle and SQLite
Features
DBLinq plans to implement all of Microsoft's Linq to SQL functionality. In addition, it has a couple of new features:
- Bulk Insert support
- User-defined global conversion from database data like auto-trimming of fixed-char columns
Partial property retrieval using single projection like:
var partialCustomer = from c in db.Customers
select new Customer { CustomerID=c.CustomerID, City=c.City };
This allows to reduce network traffic, select and update properties you really need.
In Linq to SQL this statement causes error "Explicit construction of entity type 'Customer' in query is not allowed."
- Database-defined enums are mapped to C# enums (added 2008-Apr).
In DBML file, these are persisted as follows: <Column Name="rainbow" Member="Rainbow" Storage="rainbow" Type="enum red, orange, yellow" DbType="enum('red','orange','yellow')" IsPrimaryKey="false" IsDbGenerated="false" CanBeNull="false" />
Community
As of 2008-March, DBLinq has two regular contributors (Pascal and Jiri). The community of users consists mainly of http://groups.google.com/dblinq newsgroup.
Main links
Home page: http://code2code.net/DB_Linq
Forum: http://groups.google.com/group/dblinq/topics
Google code page: http://code.google.com/p/dblinq2007
Anonymous SVN: http://dblinq2007.googlecode.com/svn/trunk/ (checkout with TortoiseSVN here)
Bugtracker: http://code.google.com/p/dblinq2007/issues/list
FAQ
Mono Support
DbLinq requires two .NET 3.5 assemblies:
- System.Core.dll
- System.Data.Linq.dll
Mono includes System.Core.dll assembly natively in 2.0 profile GAC.
System.Data.Linq.dll is present in Mono Olive project. System.Data.Linq.dll can be downloaded from Mono SVN and compiled manually.
npgsql, ADO .NET data provider for PostgreSQL used by DbLinq has been tested and works with Mono. There is a proposed "Google summer of Code" project that is to make DbLinq available on Mono.
And this nice logo?
Tony Hild did it for us. All versions are in the Logo page.
Addicted toThe best C# & VB.NET refactoring plugin for Visual Studio 2005