mySQL stored procedures in VS 2012

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
zolotoy
Posts: 2
Joined: Mon 15 Oct 2012 19:03

mySQL stored procedures in VS 2012

Post by 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

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: mySQL stored procedures in VS 2012

Post by 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/ ... nitor.html

Post Reply