Can i use LINQ with MySql database?

Question

 

Hi all,

Can i use LINQ with MySql database?

 

If yes , what i need to do this?

 

 

Regards

Gunwant 

Answer 1

Hi Gunwant

 

Yes, you can.

Use LINQ for NHibernate.

http://www.ayende.com/Blog/archive/2007/03/16/Linq-for-NHibernate.aspx

 

If you want to set up a Multi-Tier infrastructure, InterLINQ could probably be a solution for you.

http://www.codeplex.com/interlinq

 

Best Regards

Manuel

Answer 2

See also this project: http://code2code.net/DB_Linq/

Answer 3

Another approach is to use the Entity Framework (aka Linq to Entities) and the EF-enabled MySql ado.net provider.  The final release of this provider is not yet available, but there was a version for beta 2 of the EF, and I expect there will be a version for beta 3 when it comes out shortly.

 

- Danny

 

Answer 4

Thanks   Fabric

 

It seems that this project is under development.

 

I need a fast solution for this.

 

could you please put a light on this.

 

Regards

Gunwant

 

 

Answer 5

I haven't heard about another solution for MySQL.

Answer 6

 

Hi Fabric,

 

I need little more elaboration on this topic.

My development is largly depend on the use of LINQ.

I want to specificaly , can i use the db_linq product on my production envoirnment.

 

Please suggest.

 

Regards

Gunwant

Answer 7

You should contact directly the author of the project, because I don't know much about it.

Answer 8

Mindscape LightSpeed 2.0 also provides an abstraction that means you can use LINQ style querying to access data from your MySQL databases. There is also rich domain modeling integration into Visual Studio 2008.

Not only is there support for LINQ to MySQL but also LINQ to PostgreSQL, LINQ to SQLite, LINQ to Oracle and, of course, LINQ to SqlServer.

There is a free version available for people working with small databases.

You can get more information here: http://www.mindscape.co.nz/products/lightspeed/

Disclaimer: I do work for Mindscape and randomly found this thread so I'm adding my 2 cents :-)

John-Daniel Trask

Answer 9

Why not try ALinq ? the bestest database linq provider! It supports MySQL, Oracle, Access, SQLite, Firebird database.
for more infomation about alinq, please visit http://www.alinq.org .

Answer 10

Yes, BUT you need to add 3rd party tools to Visual Studio like, "dotConnect for MySQL":

dotConnect

There are other tools as well.

I use a linq to sql (MSSQL) on my site <snip> instead of using mySQL, because I can do all the work on VS (no need for 3rd party software).

Answer 11

Quick and easy solution for MySql in VS.Net 2010:

- install MySQL Connector/Net (from: http://dev.mysql.com/downloads/connector/net/6.0.html)
- add reference to MySql.Data
- use the built-in ADO.Net Entity Data Model in Visual studio

to know which version of mysql/connector/.net is supported:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-versions.html

Answer 12

i did all 3 steps, what is the next thing to do?

Answer 13

Create an instance of your entity model.. and use LINQ to query tables..

TestEntities oTestEntities = new TestEntities();
var q = from t in oTestEntities.MyTable select t;
MessageBox.Show(q.Count().ToString());

Answer 14

Try to use 3-rd parties. For example, Devart LinqConnect offers you a nice L2S engine for MySQL.

---

Ramesh

Answer 15

http://gautam-m.blogspot.com/2011/01/introducing-adonet-entity-framework.html