EntityFrameWork MySql Routines Out Paramter?

Hello Wolrd!

How to get out parameter of Mysql routines using EntityFramework.

Thanks in advance!

Re: EntityFrameWork MySql Routines Out Paramter?

Output parameters are returned in ObjectParameter instance. So you can use following code:

var result = new ObjectParameter("dbOutParamName", typeof(string));
var result = ctx.MyFunction("XYZ", result).ToList();
var data = result.Value.ToString();

Re: EntityFrameWork MySql Routines Out Paramter?

Your code works good for sqlserver.

But same code will not work of MySql.

I'm getting null as outparamter

Re: EntityFrameWork MySql Routines Out Paramter?

Hi,

You can refer to the below links. It has a complete sample in the below link about how to access MySql in .net.

http://www.codeproject.com/Articles/35662/Mysql-Data-Access-Layer

http://stackoverflow.com/questions/1235792/what-is-a-good-way-to-handle-returned-data-from-mysql-and-c