Announcing DbLinq 0.20
Jonathan Pryor
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.