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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to