mySQL stored procedures in VS 2012

mySQL stored procedures in VS 2012

Postby zolotoy » Mon 15 Oct 2012 19:39

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
zolotoy
 
Posts: 2
Joined: Mon 15 Oct 2012 19:03

Re: mySQL stored procedures in VS 2012

Postby Shalex » Fri 19 Oct 2012 16:33

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/docs/?DbMonitor.html
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL