Re: [Firebird-net-provider] Stored procedures etc. in .NET

[Alexander Muylaert-G. <amu...@ho...>]

Hi Jiri
There is interest on our behalf.  But we will only switch to FB 3... after release 2 or something like that.That doesn't mean we are not interested in kicking this into motion.

Thanks
Alexander

> From: ji...@ci...
> To: fir...@li...
> Date: Mon, 27 Jun 2016 20:51:31 +0200
> CC: fir...@li...
> Subject: [Firebird-net-provider] Stored procedures etc. in .NET
> 
> Hi *,
> 
> there's something I've been working on for a few evenings and weekends.
> As you might know, from Firebird 3 there's and interface to write a
> plugin that allows to execute any code as stored procedure, function or
> trigger.
> 
> So why not to have these in .NET, right? I have a working plugin right
> now. Currently only stored procedures are supported. No blobs at the
> moment as well.
> 
> You can check small example at the end of this email.
> 
> Now the important part. Is there enough interest in this to keep working
> it? The hardest part is mostly over. Now it's just adding support for
> more objects and polishing it, hardening it and probably adding features
> based on requests (like security).
> 
> * SP:
> recreate procedure demo (
>   in_int integer,
>   in_s varchar(20),
>   in_long bigint,
>   in_short smallint,
>   in_char char(20)
> ) 
> returns (
>   out_int integer,
>   out_s varchar(20),
>   out_long bigint,
>   out_short smallint,
>   out_char char(20)
> )
> external name 'Example!Example.Procedures.Demo'
> engine dotnet;
> * Code (not sure about the tuples yet):
> public static IEnumerator<Tuple<int?, string, long?, short?, string>>
> Demo(int? i, string s, long? @long, short? @short, string @char)
> {
> 	yield return Tuple.Create(i, s, @long, @short, @char);
> 	yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
> 	(short?)(@short + 1), @char);
> }
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider