Re: [Firebird-net-provider] DDEX and calling a parametrized stored proc that returns a rowset

2009-07-02 Thread Jiri Cincura
On Thu, Jul 2, 2009 at 16:54, Sam Carleton wrote: > I thought I had another solution working, but that solution blow up today, > so I am back:)  I have tried making the command "Text" and setting the SQL > to: > > SELECT * FROM UDA_GET_QUESTIONITEM_BY_ID_SP(@ID, @ACTUAL_VERSION) > > I am getting an

Re: [Firebird-net-provider] DDEX and calling a parametrized stored proc that returns a rowset

2009-07-02 Thread Sam Carleton
On Sat, Jun 27, 2009 at 5:15 AM, Jiri Cincura wrote: > On Fri, Jun 26, 2009 at 17:47, Sam Carleton wrote: > > Like I said before, when I go in and code up the FbCommand by hand and > > set the CommandText to "SELECT * FROM GET_TARGETTABLE_BY_ID_SP( ?, > > ?)", CommandType to Text, and set the par

[Firebird-net-provider] Firebird v2.1.1 / v2.1.2 / beta v2.5 running on Windows Vista Ultimate 32-bit -- Exception on CreateDatabase using localhost

2009-07-02 Thread Brian Hartmann
I have searched the archives for this list, and the web in general, finding no reference to the issue I am facing. Also, I have tried many experiments, as mentioned below. The issue is that when the program tries to create a new database (FirebirdSql.Data.FirebirdClient.FbConnection.CreateDat

[Firebird-net-provider] IronPython2.0 on Ubuntu 9.04

2009-07-02 Thread marius adrian popa
Maybe it can be used with fbconsole (on the same blog page) , i will add it on my todo list for testing it http://translate.google.com/translate?hl=en&sl=ja&tl=en&u=http://nakagami.blog.so-net.ne.jp/2009-06-30 -- ___

Re: [Firebird-net-provider] Generated primary key columns in EF

2009-07-02 Thread Jiri Cincura
On Thu, Jul 2, 2009 at 14:36, Alexander Muylaert wrote: > We actually solved this by writing a small command line tool that we call > from our pre build events.  It prepares the XML file for real usage.  (Don't > save the edmx file if you haven't changed anything, our your build will take > minutes

Re: [Firebird-net-provider] Generated primary key columns in EF

2009-07-02 Thread Jiri Cincura
On Thu, Jul 2, 2009 at 14:08, sasha wrote: > 1) This question should be discussed in fb-devel and i think that new > feature should be added to server for this And BTW even if it will be added, it'll not be in 2.5 (as only one able to get proper result to build model correctly) nor in 3.0 probably

Re: [Firebird-net-provider] Generated primary key columns in EF

2009-07-02 Thread Jiri Cincura
On Thu, Jul 2, 2009 at 14:08, sasha wrote: > 1) This question should be discussed in fb-devel and i think that new > feature should be added to server for this I think, that the server can do nothing with it. And I do not like autoincrement columns. Generators/Sequences are much more powerfull. On

Re: [Firebird-net-provider] Generated primary key columns in EF

2009-07-02 Thread Alexander Muylaert
We actually solved this by writing a small command line tool that we call from our pre build events. It prepares the XML file for real usage. (Don't save the edmx file if you haven't changed anything, our your build will take minutes each time). Since all our ID's always are called "ID" we just

Re: [Firebird-net-provider] Generated primary key columns in EF

2009-07-02 Thread sasha
> as there's no way in FB to know that the PK column is autogenerated > using generator (at least I don't), you have to tweak the model to set > this up. Unfortunately every update of model will remove this. I'm > thinking about some special mark (anywhere) in comment to let me know > to mark this