c# - How to connect to a MySQL database inside the .NET framework? -


i'm opening discussion here on subject couldn't find answer enough called final answer: mysql , .net.

while know there lot of ways make connection, i'm trying find list of pros , cons of each approach.

i've been using ado.net mysql netconnector since beggining of project, , ok when database new , didn't have many records. i'm facing situation number of records grows exponentially, , found other way of querying against database, odbc connector. using ado.net + netconnector solution had o/rm , didn't have write queries, while odbc makes code awful (since didn't switch odbc, have linq queries , plain sql queries inside code).

is there solution (free or not) can have both o/rm without need of writing sql queries myself , speed of odbc?

what should doing using mysql ado.net connector , storing queries in database in form of stored procedures. version 6.0 of mysql connector supports the entity framework. if interested in using entity framework, check out this link describes how set up.


Comments

Popular posts from this blog

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

java - Why is BlockingQueue.take() not releasing the thread? -

jQuery Ajax Render Fragments OR Whole Page -