Menu
I've been looking around for a definitive answer as to how to use LINQ to SQL with mySQL but can't seem to come up with anything. Does anyone have any experience / suggestions using the two together? In particular, I would like to avoid using string SQL statements.
Cheers
808
LinqConnect is a lightweight, LINQ to SQL-compatible ORM solution with support for MySQL, Oracle, PostgreSQL, and SQLite.
LINQ to SQL translates the queries you write into equivalent SQL queries and sends them to the server for processing. More specifically, your application uses the LINQ to SQL API to request query execution. The LINQ to SQL provider then transforms the query into SQL text and delegates execution to the ADO provider.
LINQ to SQL was the first object-relational mapping technology released by Microsoft. It works well in basic scenarios and continues to be supported in Visual Studio, but it's no longer under active development.
MySQL isn't directly supported by Microsoft's LINQ to SQL provider, but there are several alternative ways you can use LINQ against MySQL. Take a look at using LINQ to nHibernate, or see here for LINQ providers against non-Microsoft databases.
92
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
