[Mono-list] Announcing DbLinq 0.20

Fri Apr 9 18:30:37 EDT 2010

The DbLinq[0] team is proud to announce the release of DbLinq 0.20,
following the venerable DbLinq 0.19 release from December 2009.

DbLinq is a reimplementation of System.Data.Linq.dll for use with SQL
servers in addition to Microsoft SQL Server.  Support is provided for:

      * Firebird [1]
      * Ingres [2]
      * MySQL [3]
      * Oracle [4]
      * PostgreSQL [5]
      * SQLite [6]
      * SQL Server [7]

Note that not all servers are supported equally: some tests will pass
under some database backends while failing under others.  I maintain the
SQLite and SQL Server backends, while the community handles the others.

My focus for this release has been on fixing DbMetal and sqlmetal
issues.  In particular, sqlmetal can now generate .dbml files.
Additionally, the CodeDom generator now works, allowing you to generate
Visual Basic .NET sources, and the older "CodeText" generator has been
deprecated (and is available via `/language:obsolete-c#`).  It will be
removed in the next release.

A horrifically unreadable list of issues fixed is at the end. [8]

Enjoy!

 - Jon

[0] http://code.google.com/p/dblinq2007/
[1] http://www.firebirdsql.org/
[2] http://www.ingres.com/
[3] http://www.mysql.com/
[4] http://www.oracle.com/
[5] http://www.postgresql.org/
[6] http://www.sqlite.org/
[7] http://www.microsoft.com/sqlserver/
[8] Part of the length of this is that all "inactive" and "unresponsive"
bugs were closed so that currently relevant bugs would actually be
visible at http://code.google.com/p/dblinq2007/issues/list
   7
Add
MySQL 4.0 support

   9
pgsqlmetal generates invalid DbType attribute for integer

  34
pgsqlmetal primary key constraint

  45
sqlmetal should generate table names without schemas

  60
DbType attribute does not contain some clauses

  67
FirstOrDefault return error

  71
DbMetal & Oracle: Tables aren't loaded

  73
DynamicQueryOrderBy

  77
DataMembers property not implemented

  78
DbLinq.Pgsql.Example.csproj contains bad project reference

  79
"contains" could not parse correctly to "like"

  80
left
column should be quoted

  82
Possibility to have all generated classes in lowercase

  83
DbLinq.Linq.DataContext' missing a constructor

  86
read
blob
from
mysql?

  88
MySql dbtype "TimeStamp" isn't supported by DbLinq.

  90
Referenced tables more than 1 times

  93
Some
LINQ
expressions  an error - no such column True

  94
Unable to read inherited types using DBLinq to Sqlite

  96
NRE
in
QueryBuilder.Upsert.cs: GetUpsertParameters method

  98
Does
dbLinq support "EntitySet"?

 101
Error saving password

 106
NullReferenceException during insert

 107
DbMetal leaves types blank for fields generating bad code

 108
DBMetal describes an unsigned integer as a signed integer

 109
MySql 5 varbinary columns are undeceted

 116
Unsupported types in Pgsql

 117
Problems in VisualMetal generated file with Pgsql

 118
DBLinq_test build fails due to missing AssemblyInfo.cs

 119
System.Data.Linq missing assembly reference

 120
ORA-02291:integrity constraint violated - parent key not found

 123
dbmetar error with firebird sample

 124
BulkInsert SqlServer fails for nullable

 125
Bug
in
association creation 

 126
Problem in SubmitChanges() in Linux

 127
Multiple associations from the same table to the same table 

 128
"Invalid column '{0}'" bad error

 129
No
support for aggregate functions with lambdas

 130
Delegate compilation error for types with nullable properties 

 131
An
error has occurred with Table<T>.Max if table no record

 134
Exception whith sqlite foreign key

 137
Bug
requesting uuid

 138
Trying to iterate through MySQL view throws an exception.

 140
While running dbmetal in VS 2008 i got the Following Error

 141
mediumtext MySql datatype not supported

 142
Joins for more than 3 tables

 143
DbMetal doesn't generate datatypes for sqlite FTS3 tables

 145
mysql: unsigned float problem

 148
LambdaMetaAccessor missing in DbLinq project

 150
Unable to update table: SQLite error no such column: true

 152
Cannot update record if primary key of table is uuid

 154
DbMetal can not create the class file for Oracle 10g

 155
Type
ommitted for "timestamp with time zone" column

 160
Duplicate methods generated for some overloaded functions

 161
"Lambda Parameter not in scope" error when calling a function

 164
GetBooleanAttribute should also return true for "True"

 165
northwind for mysql

 170
Can't use DbMetal with port numbers

 171
SqlMetal can't generate DBML files

 172
ria
services

 173
DbMetal generates method names with uppercase and lowercase

 175
Cannot update records in postgresql - invalid cast
 180
sqlite_sequence table in sqlite breaks code generation

 181
Dbmetal can not generate "ref cursor" in Oracle

 183
DbMetal can't generate source from a DBML file.

 184
DBMetal cannot connect on different port

 194
dbmetal fails to filter on schema

 195
dbmetal doesn't handle foreign keys on multiple columns

 196
Storage and member aliasing fails for more > 2 associations

 197
error when table, used implicitly in select-clause, is used explicitly in where-clause

 198
Column names with leading digit produce invalid C#

 199
DbMetal.exe throws exception.

 200
the
given key was not present in the dictionary

 202
Using sqlmetal on Mono generate invalid Using

 208
Problem with binary column as primady key

 209
Fixed builder sql bug.

 212
DbMetal can't resolve databaseconnectiontype for mysql

 213
DbLinqProvider is loaded using the wrong assembly load context; 

 215
System.ArgumentNullException from 'DbMetal /provider:Sqlite'

 216
DbMetal.exe gen sqlite dbml got error in vs2008

 217
DbMetal: Don't know how to convert the SQL type ''

 218
QueryCacheEnabled=true not working on subsequent reads

 219
DatabaseTransaction.Dispose might fail to clear...

 220
Invalid code generated with DbMetal --generate-equals-hash`

 221
Cleanup C# Code Generators

 224
DbMetal doesn't generate nullable types like .NET.

 228
DbMetal generates invalid DBML

 229
check to see if provider assembly is already loaded

 230
tables without primary keys don't get change notification. 