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