Page 1 of 1

mySQL stored procedures in VS 2012

Posted: Mon 15 Oct 2012 19:39
by zolotoy
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

Re: mySQL stored procedures in VS 2012

Posted: Fri 19 Oct 2012 16:33
by Shalex
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