Accessing MYSQL database using LINQ in asp.net MVC

Question

hi

I want to use MYSQL database for accesssing the data in a mvc application.

The connection string that i am using in web.config is:

Then I have prepared a model,controller,view for accessing and displaying the data.

I am using LINQ o get the data from database but getting the exception:" A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

I have also installed the MYSQL connector.

Please provide me the solution to access the data using MYSQL and LINQ in MVC application

Thanks in advance.

Answer 1

You can't use LINQ to SQL. You should use entity framework. Linq to SQL is only for MS Sql. Use EF to work with any other DB, and then you can use LINQ to EF.

Linq to SQL is obsolete http://blogs.msdn.com/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx

Answer 2

Deleting my previous answer...I read your question as LINQPad, no idea why.

To be short, get a third party provider, I can't speak for others, but devart's dotConnect for Oracle has worked very well for us: Here's their MySQL version.

Answer 3

You could use NHibernate and Linq-to-Nhibernate and then you are not database tied.

NHibernate Files http://sourceforge.net/projects/nhibernate/files/

But this I guess is dependent on how much time you have to develop!