Thank you for your reply. Here is my attempt to run DbMetal. You will see it fails I would appreciate any help/pointers.
C:\Data_Root\Temp\DbLinq-0.20.1>dbmetal.exe --provider=Mysql --server=192.168.0.7 --database=in_out --user=sid --password=xxxxxx --code=files\dblinq_mysql.vb DbLinq Database mapping generator 2008 version 0.20 for Microsoft (R) .NET Framework version 3.5 Distributed under the MIT licence (http://linq.to/db/license) DbMetal: Could not load databaseConnectionType type 'MySql.Data.MySqlClient.MySq lConnection, MySql.Data'. Try using the --with-dbconnection=TYPE option. Sid. Avian Ambassadors - Flights of Education www.AvianAmbassadors.com <http://avianambassadors.com/BirdTraining/> The Bird Training Blog <http://www.behaviorandtraining.com/> Behavior and Training Seminars From: [email protected] [mailto:[email protected]] On Behalf Of Sadik Eser Sent: Monday, January 10, 2011 12:46 AM To: [email protected] Subject: Re: [dblinq] Novice needs help Download dblinq binaries and copy "Mysql.Data.dll" in the same forder with "DbMetal.exe" using command line execute DbMetal.exe with the following parameteters, with making necessary replaces. DbMetal.exe --provider=Mysql --server=[your server address] --database=[your database name] --user=[mysql user name] --password=[mysql password] --code=[path to vb file] add the generated vb file into your project. create an instance of generated class with "connection string" parameter. if you have trouble with using dblinq please also specify the step you have troubled. Best regards Sadık Eser 2011/1/10 Sid Price <[email protected]> Hello, I am working on a project that needs to work with either a desktop DB (SQL Express 2008) or a remote DB (MySQL). I have downloaded and installed the MySQL connector and I am able to connect to a test MySQL DB. I plan on using LINQ for access of the databases and found DBLinq, it looks like it is what I need to access MySQL using LINQ. However, I am not a DB expert and I just don't understand what steps I need to take to get DBLinq working with VS 2008 and VB.NET. I have read the instructions but really don't understand the steps I need to take. Also, when it comes to deploying my application is there anything special I need to do in order to use DBLinq so that I can offer the user an option to enter the URL to the NySQL database at runtime. Please could someone help me get this set up. Many thanks, Sid. -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected] <mailto:dblinq%[email protected]> . For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
