Re: [Firebird-net-provider] Insert into uncommitted table
What the problem with inserting in different transactions? Have you tried Read uncommited/Consistent read? 2014-12-22 14:08 GMT+02:00 Jiří Činčura j...@cincura.net: Hi *, Anybody knows a trick how to insert into freshly created table without commiting that DDL first. It's kind of fucking up first migration. :) Basically: Start TX. Create table. Insert into table. Commit TX. -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
A) The transaction is handled by EF. B) When the script gets generated, there’s no transaction whatsoever. Crazy world. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
On 2014.12.22 2:08 PM, Jiří Činčura wrote: Hi *, Anybody knows a trick how to insert into freshly created table without commiting that DDL first. It's kind of fucking up first migration. :) Basically: Start TX. Create table. Insert into table. Commit TX. Hi Jiri Something like Seed ? Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
On 22-12-2014 13:08, Jiří Činčura wrote: Hi *, Anybody knows a trick how to insert into freshly created table without commiting that DDL first. It's kind of fucking up first migration. :) Basically: Start TX. Create table. Insert into table. Commit TX. No, not really. But EF doesn't support this? AFAIK there are more databases that require a commit before a newly created table can be used. Mark -- Mark Rotteveel -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
Something like Seed ? No, not really. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
AFAIK there are more databases that require a commit before a newly created table can be used. The good old magic MS SQL does not. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider