I have a problem. In my Visual Studio 2010 project I have added a new DataSet ( using the wizard ) from our database.
When I go to the Dataset I have created, I see all of my tables and stored procedures. On one of my table I have added a new sql query to the TableAdapters.
Now is my question how do you call that specific method?
For example I have a Table called 'Countries' and in my TableAdapter ( CountriesTableAdapter ) I have created FillCountriesByEurope and GetCountriesByEurope methods.
When using SQL Server you can call the TableAdapters from the DataSet created by DataSetNameTableAdapters. When using dotConnect for mysql you don't have this option ???
Call TableAdapter methods
Re: Call TableAdapter methods
dotConnect for MySQL generates datasets basing on MySqlDataTable which replaces Devart.Data.MySql.MySqlConnection, MySqlCommand, MySqlDataAdapter, and MySqlCommandBuilder classes with all-in-one class:Mi7chVB wrote:When using SQL Server you can call the TableAdapters from the DataSet created by DataSetNameTableAdapters. When using dotConnect for mysql you don't have this option ???
http://www.devart.com/dotconnect/mysql/ ... Table.html.
That's why there are no TableAdapters in our code generation.