Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

LINQ to MySQL - what is the best option?

Tags:

mysql

linq

Has anyone used any of the utilities out there for LINQ to MySQL? Do you know which one is best?

So far I know of LINQ for NHibernate, and DBLinq

like image 545
Larry Watanabe Avatar asked Sep 23 '09 23:09

Larry Watanabe

People also ask

Does LINQ to SQL work with MySQL?

LinqConnect is a lightweight, LINQ to SQL-compatible ORM solution with support for MySQL, Oracle, PostgreSQL, and SQLite.

Should I use LINQ to SQL?

More importantly: when it comes to querying databases, LINQ is in most cases a significantly more productive querying language than SQL. Compared to SQL, LINQ is simpler, tidier, and higher-level. It's rather like comparing C# to C++.

What you can do with LINQ to SQL?

LINQ to SQL supports all the key capabilities you would expect as a SQL developer. You can query for information, and insert, update, and delete information from tables.

1 Answers

There is also LINQ to LLBLGEN, which then can support many, many databases.

From LLBLGEN's Feature Page

Support for SQL Server (MSDE, SQL Server 7/2000/2005/Express, SQL CE 2.0, 3.0, 3.5), SQL Server CE Desktop (New!), Oracle (Oracle 8i / 9i /10g), PostgreSQL 7.4+/8.x, Firebird 1.x / 2.x, IBM DB2 UDB (7.x/8.x/9.x), MySQL (4.x, 5.x), Sybase Adaptive Server Enterprise (ASE) (New!), Sybase SQL iAnywhere (ASA) (New!) and MS Access 2000/XP/2003/2007

like image 82
TonyOssa Avatar answered Oct 09 '22 03:10

TonyOssa
Sign in to Comment

Related questions

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
Using MySQL in Flask
combining mysql AND OR queries in Codeigniter
Create if an entry doesn't exist, otherwise update?
phpMyAdmin allow remote users
PHP date showing '1970-01-01 ' after conversion
How to update field to add value to existing value?
Query to toggle boolean value in MySQL [duplicate]
WampServer - mysqld.exe can't start because MSVCR120.dll is missing
How to write a stored procedure in phpMyAdmin?
Can not increase max_open_files for Mysql max-connections in Ubuntu 15
Multiple COUNT() for multiple conditions in one query (MySQL)
How to generate unique id in MySQL?
Check if mysql database exists, perform action based on result
Laravel 5.1 Migration and Seeding Cannot truncate a table referenced in a foreign key constraint
Mysql select distinct
Laravel: Get the ID of User::create and insert new row using that ID
How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
File Storage for Web Applications: Filesystem vs DB vs NoSQL engines
MySQL: Select N rows, but with only unique values in one column

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!