The begining of the discussion is here:
https://github.com/cincuranet/NETProvider/pull/2
Implementation:
https://github.com/zabulus/NETProvider/commit/6f9b7621cef4d9862ce6acb7c8fd8c9764ad7397
Main point is to add auto-generating values for PK column with specified
DatabaseGeneratedOption.Identity.
Problem is how to configure behavior of such autogeneration.
My implementation creates separate generator for each PK in all tables and
uses IBExpert-like naming. Cincuranet suggests that it should be somehow
configurated, because some users might want to have one generator for all
PKs in database, and configurable naming for generator and before insertion
trigger.
I had suggested to use app.config separate section like entity framework
does. Something like the follow:
<configSections>
<section name="firebird.client.net" type="FirebirdConfigurationHandler"
/>
</configSections>
<connectionstrings>
<add name="exampleConnectionString"
connectionString="<some connection string values>"
provider="FirebirdSql.Data.FirebirdClient" />
</connectionstrings>
<firebird.client.net>
<IdentityBehavior connectionString="exampleConnectionString"
generating="separate/shared" naming="some/naming/shemes" />
</firebird.client.net>
What else can be added to such configuration regarding to auto-generated
values?
What other options or option values can be suggested?
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Add-auto-generated-identity-for-primary-key-column-tp4635338.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
