[Mono-list] Announcing DbLinq 0.20

Jonathan Pryor jonpryor at vt.edu
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. 







More information about the Mono-list mailing list