DbLinq

That's just a link back to this thread. My post was a follow-up to the suggestions you already gave me, and I already have those updated dlls. I'll try using DBLinq itself at some point for my project, but your updated dlls don't seem to be working in Mono, so any upcoming 2.6.8 release still won't work on Windows.

Mono 2.6.7 is busted; see: [link] - Jon

Yes, Mono ships with sqlmetal.bat, which calls mono.exe with the full paths. I thought I had mentioned that, but I don't see it in the thread. My last post was intended to demonstrate that the correct sqlmetal was called by the batch script, so address your point about precedence of .exe/.bat and which sqlmetal was being called:

Hello to all I create new UI for work with SQLite and DBLinq SQLite easy and fast you can find it on this URL [link] Thank you Mohsen Ahmadian

MySql does not like the "DbLinqProvider" option pass to its MySqlConnection(). It gave me an error complaining that it was not a valid MySql connection option. However, passing the connection string to the generated DataContext as shown below worked. var db = new MySqlSampleDb("DbLinqProvider= MySql; " +

... ... [link] Your problem is that your connection string is missing the DbLinqProvider parameter. Consequently DbLinq assumes you're targeting Microsoft SQL Server, and thus produces MSSQL-style SQL instead of MySQL-style SQL. The fix is to add a DbLinqProvider=MySql parameter:

Thanks. It worked. My project compiles. But running it caused an error: Unhandled Exception: MySql.Data.MySqlClient.MySqlEx ception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[ISBN], [Title], [AvailableDate]

... Not sufficient. sqlmetal is, for all intents and purposes, DbMetal, thus the following applies: [link] Specifically the "There are three ways that the ADO.NET provider can be used with DbMetal.exe" section: If your ADO.NET provider is present within the Global Assembly

Both. I started with the mono bundle but that was troublesome. Then I got it through google code. The mono bundle referenced the ByteFX connector so I downloaded the MySql Connector/Net from the MySql site too and reference it using the databaseConnectionProvider option is sqlmetal. Have you successfully got this on mono to work? If so, can

Is this with the mono bundled dblinq or the download at google code? Regards, James Darbyshire Sent from my Samsung Droid™ Hi, I'm testing out Linq to MySql. I downloaded the latest MySQL Connector/Net from the MySQL site. I have a simple mysql database with 1 table in the schema. When I executed the command below: