Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Jiří Činčura
> 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 Paralle

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Jiří Činčura
> 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 S

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Mark Rotteveel
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.

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Mercea Paul
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 Someth

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Jiří Činčura
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 Enterpris

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Геннадий Забула
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 : > Hi *, > > Anybody knows a trick how to insert into freshly created table without > commiting that DDL first. It's kind of fucking up first migrati

[Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Jiří Činčura
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 --