I have just downloaded and installed the latest trial version of dotConnect for MySQL. I cannot get results of a stored procedure. It runs, but data is empty. Any idea?
Thanks
mySQL stored procedures in VS 2012
Re: mySQL stored procedures in VS 2012
1. Check via any database management tool that your stored procedure itself returns non-empty result set.
2. How do you envoke stored procedure (plain ADO.NET, Entity Framework, etc)? How do you process the returned data? Please send us a small test project with the corresponding DDL/DML script to reproduce the problem in our environment.
JIC: the dbMonitor tool can be used to perform per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation:http://www.devart.com/dotconnect/mysql/ ... nitor.html
2. How do you envoke stored procedure (plain ADO.NET, Entity Framework, etc)? How do you process the returned data? Please send us a small test project with the corresponding DDL/DML script to reproduce the problem in our environment.
JIC: the dbMonitor tool can be used to perform per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation:http://www.devart.com/dotconnect/mysql/ ... nitor.html