Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linq and MySql

Status
Not open for further replies.
murrayja

murrayja

Programmer
May 6, 2000
90
0
0
US
I have used Linq with MsSql and now I want to use it with MySql.
I add a Linq to Sql class to my project and create a database connection, in the database explorer, to my MySql database. When I drag a batabase table to my linq class I get the message ...
"the selected objects use an unsupported data provider" ...

The properties of my connection show it using 'MYODBC3.DLL" as the driver. The data provider is '.NET Framework Data Provider for ODBC'.

I can inspect the tables of my mysql connection including the data in those tables so I don't know why it is not a supported data provider.

 
Sort by date Sort by votes
From my understanding LinqtoSQL is only support on MSSQL.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sugu1
  • Locked
  • Question
sound editing in web site to record, cut/trim, paste and save as wav file
Replies
0
Views
127
sugu1
sugu1
tfstom
  • Locked
  • Question
Linq sort a list inside another list
Replies
0
Views
39
tfstom
tfstom
engsalah2018
  • Locked
  • Question
How to get label text from table reference on database based on TableName and FieldName
Replies
2
Views
137
jbenson001
jbenson001
ahm1985
  • Locked
  • Question
select item from city not fill items in district drop down linq
Replies
0
Views
45
ahm1985
ahm1985
XgrinderX
  • Locked
  • Question
MVC Entity Framework MSSQL and MySQL in same project
Replies
6
Views
119
XgrinderX
XgrinderX

Part and Inventory Search

Sponsor

Back
Top