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

[Rick R. <ric...@gm...>]

I'm using FB3 for a new commercial app now and I'm interested.  For me,
there are many occasions where I have had to write something in an SP that
would have been much easier in .NET simply because I use it every day and
SQL less often.
Keep us informed on the progress.

Regards,
Rick

On Mon, Jun 27, 2016 at 2:50 PM Alexander Muylaert-Gelein <
amu...@ho...> wrote:

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