>Code2Code.net Home   >Contacts   >Credits   >Links   >Other Translation Engines

DbLinq Project: Linq Provider for PostgreSQL

Postgres-Specific Notes:

1. Added basic support for PostgresSQL (version 8.2)
2. Added initial support for GROUP BY clauses.
2b.  some 'GROUP BY' queries that will be accepted by Mysql will throw an exception in PostgreSQL:
    SELECT CustomerID, OrderID FROM orders GROUP BY CustomerID 
    ERROR: column "orders.orderid" must appear in the GROUP BY clause or be used in an aggregate function
     SQL state: 42803



Getting Started:

1. Download general DbLinq required items, listed on the main project page
2. Download Postgres 8.2 
3. Download DbLinq.Postgres.zip
4. run PostgreSqlMetal.exe against your existing database to create a schema .cs file
5. Add the cs file and DbLinq.Postgres.Prototype.dll to your .NET project