code2code.net

“includes fixes and SqlLite support by Douglas Six and Peter Magnusson” - grab it form the downloads page. Discuss on the newsgroup.

What’s coming next (in March)? A big refactoring by Pascal, which should move provider code into separate DLL. Also planned is partial support for vertical partitioning.

I am looking for volunteers are required to create a graphical SqlMetal tool, which would allow you to rename fields and change types, and control partitionaing and other mapping.

Good luck everyone!

What’s in it?

Work on large DBs, composite PKs, PostgreSql schemas, self-joins, bug fixes …

Download from google.

This release includes work on stored procs, client-side enums, SQL bulk insert, addition of some ‘101 Linq Samples’, fixes for ‘IS NULL’ clauses.

The project has also been re-licensed under MIT license, to be compatrble with Mono.

Orcas Beta2 (Visual Studio 2008) has been released. I like the VirtualPC image, allowing me to use it at work - but avoid the direct installation, which has installed .NetFramework2-SP1 on my machine, causing many .NET 2 apps to stop working.
For LINQ, there are some changes in Beta2: anonymous types are now immutable (except VB.net - read about the new keyword, ‘Key’), and as such the dynamically-compiled code under the hood needs to change. You can download the updated source code package from http://code.google.com/p/dblinq2007/

Side note on Spam in Wordpress:
Since I tweaked the submission page to add an extra question, I am down from some 10 spammers to 1 spammer. He still visits me faithfuly every day. Not sure how many genuine submissions were lost.

The Linq provider achieved a milestone by getting it’s first package created - by Bryan Livingston (plug). Thanks!

New in this release:
- Migrated to Visual Studio Orcas Beta 1
- new back ends: Linq provider for PostgreSQL and MSSQL
- support for GROUP BY and HAVING clauses
- Linq to Oracle project suspended, as my Oracle machine not alive
- renamed from Linq_MySql to DB_Linq to reflect multiple back ends

Unrelated: How do you deal with a wordpress blog swamped by 3000 spam comments? Unable to use the moderation page, I resorted to a MySql delete statement … Any better ideas? (Update: added an extra field on the submit page to break from the monoculture - monoculture is always easy to infect)

Please visit code2code.net/Linq_Mysql to read about it and get the source.

Thanks!

Please post notes on other translations (and links).

One of output ‘languages’ is XML, which allows you to retrieve parsed data and write your own ‘front end’.

Please discuss below.

The VB.Net is incomplete.
We currently seek advice on the cleanest translation of the C++ ‘for’ loop.

Please reply below.

For C# suggestions and comments, please reply here