Re: [Firebird-net-provider] Views and Entity Framework

2012-04-06 Thread diegodelafuente
I tried the workaround for views and tables without success. Message 1 The table/view 'Firebird.Firebird.EMPRESA' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view. C:\VStudio2010\Turnos .NET - Sebastian\Desarrollo 5-4

Re: [Firebird-net-provider] Views and Entity Framework

2011-06-05 Thread Jiri Cincura
On Sat, Jun 4, 2011 at 19:02, Takeshi Kabuto wrote: > "Warning    6    Error 6013: The table/view 'Firebird.Firebird.ORDERS' does > not have a primary key defined and no valid primary key could be inferred. > This table/view has been excluded. To use the entity, you will need to > review your sche

Re: [Firebird-net-provider] Views and Entity Framework

2011-06-04 Thread Takeshi Kabuto
I used: COMMENT ON column Orders.ID IS '#PK_GEN#' Orders is a view. When I go to IbExpert application to examine the view. I can see #PK_GEN# in the description column. It seems that the view is ok according the specifications. Then I go to VS2

Re: [Firebird-net-provider] Views and Entity Framework

2011-06-04 Thread Jiri Cincura
On Sat, Jun 4, 2011 at 17:18, Takeshi Kabuto wrote: > Am I doing something wrong or the reason is that #PK_GEN# workaround is > not supported for views? You're doing something wrong. It is supported on views. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3

[Firebird-net-provider] Views and Entity Framework

2011-06-04 Thread Takeshi Kabuto
Does #PK_GEN# technique work for views in the EF? I have added '‘#PK_GEN#' as a comment of an integer column of a view. This column is the primary key of the underlying table. However, the EF does not infer the primary key. Am I doing something wrong or the reason is that #PK_GEN# workaround is n

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread Jiri Cincura
On Wed, Aug 25, 2010 at 14:39, sasha wrote: > But table also can be without PK. What will provider do if find such table? Provider will do nothing. Provider only reports database structure to EF. EF generates the model. Ultimately the table without PK not be used by EF. -- Jiri {x2} Cincura (x2

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread sasha
> That's not good. Views are by default without PK, developer must say > what's part of PK and what's not. Blindly marking all column as PK > (not taking into account, that i.e. byte[] cannot be part of PK) may > result in wrong data. But table also can be without PK. What will provider do if find

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread Jiri Cincura
On Wed, Aug 25, 2010 at 14:20, sasha wrote: >> Me? Why me? > I mean by default, as provider developer, during model importing :) That's not good. Views are by default without PK, developer must say what's part of PK and what's not. Blindly marking all column as PK (not taking into account, that i

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread sasha
> Me? Why me? I mean by default, as provider developer, during model importing :) > Edit SSDL and use smallint_bool as datatype. I should do this once or each time after i update model from database? -- Sell apps to

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread Jiri Cincura
On Wed, Aug 25, 2010 at 13:35, sasha wrote: > But why don't you want to make all columns as keys? Me? Why me? > Another question. We have "bit" fields in MSSQL, which translated to > boolean properties in the model. Is there some possibility to make the > same in FB until #BOOL# hint is not impl

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread sasha
> http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/ Thanks. But why don't you want to make all columns as keys? Another question. We have "bit" fields in MSSQL, which translated to boolean properties in the model. Is there some possibility to make the same in FB until #BOOL#

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread Jiri Cincura
On Wed, Aug 25, 2010 at 12:46, sasha wrote: > Did you > try to import views? http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/ -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Views in EF

2010-08-25 Thread Jiri Cincura
On Wed, Aug 25, 2010 at 12:46, sasha wrote: > Did you > try to import views? Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Sell apps to millions through the I

[Firebird-net-provider] Views in EF

2010-08-25 Thread sasha
Hi, Jiri. I have database with views, but i can't import them into model. Did you try to import views? -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and re

Re: [Firebird-net-provider] Views

2006-04-15 Thread Jiri Cincura
On 15.4.2006 4:15 Eduardo Beninca wrote: Hi, i need a help with views.. I want to call a view inside my c# code ... how can i do this ??? View is like the normal select. So FbCommand x = new FbCommand("select * from some_view;", connection, transaction); x.Execute ... -- Jiri Cincura htt

[Firebird-net-provider] Views

2006-04-14 Thread Eduardo Beninca
Hi, i need a help with views.. I want to call a view inside my c# code ... how can i do this ??? -- "I throw myself into the sea Release the wave, let it wash over me To face the fear I once believed The tears of the dragon, for you and for