From Ingres Community Wiki

                                                                                                                                                                                                     

                                                                                                                                                                                                     

                                                                                                                                                                                                     

                                                                                                                                                                                                     

Ingres Linq Driver

Projects Home

Home

Project

Documentation

Support

Bugs

Requests

Patches

Downloads

News

As of 19th May 2008 the first version of DbLinq with Ingres Support has been released! To check it out you can download it from the project homepage.

About Linq

Linq is an O/R (Object-Relational) mapping tool, with some similarities to Hibernate. Linq is type-safe, queries get compiled into MSIL on the fly, and your C# WHERE clauses are translated into SQL and sent to the DBMS server for execution. In short, it makes design of data access layers safer and faster. In C# 3.0, linq code looks like this:

 var q = from p in db.Products             
         where p.ProductName == "Pen"  
         select p.ProductID;  

The community of the DbLinq developers consists mainly of the people in the Google DbLinq newsgroup.

Also, visit oloh for project statistics.

Aims

This Community Project aims to contribute an Ingres Plugin for the DbLinq project, an alternative implementation of Microsoft Linq. DbLinq is an independent open source project, there is no financial support by any database vendor or software company. In that effect DbLinq aims to target as many databases as possible. Currently supported in the svn/trunk version are: Ingres, PostgreSQL, Oracle, MySQL and SQLite. Also DbLinq aims for platform independence. So eventually it will run not only under MS .NET 3.5 but also on Mono Olive and the various platforms Olive targets.

Getting Started

If you want to drive it around the block, have a look at the DbLinq Ingres Getting Started Guide

Current Status

The current Roadmap for DbLinq can be found here. The May release of DbLinq (0.17) is the first version to have support for Ingres.

What works:

• Schema reengineering using DbMetal
• Most of the Linq language patterns are usable

What doesn't work:

• No support for Ingres stored procedures yet. Maybe the next release will contain that.
• No support for Ingres DB events (I think not even the .NET Data provider supports those)

For an overview of the working NUnit tests at the moment please visit the test page

Project Profile