On Sun, Sep 19, 2010 at 01:38, sasha <trofim...@gmail.com> wrote:
> The biggest problem is views. You said that you don't include views into
> model because lack of information about keys.
Not *me*. It's Entity Framework that needs keys and designer that
doesn't include views (in case it cannot infer some key).
> I've just made test database with one table and one view based on this
> table. After that i've tried to import model and make my view working in EF.
>
> For this i should:
> 1) Add EntitySet in EntityContainer in SSDL
> 2) Add EntitySet in EntityContainer in CSDL
> 3) Uncomment EntityType in SSDL
> 4) Add key fields in SSDL
> 5) Add similar EntityType in CSDL (with key fields).
> 6) Correct design of model in designer.
>
> Dou you think it's normally if programmer will make all this???
> Do you think it's easy to make such changes on real database???
This isn't shortest path. You can update model from database,
uncomment part in SSDL and specify keys. That's it. CSDL stuff you can
do in designer or maybe you already have this entity prepared, so you
just need to map it.
> It's funny that almost all of this programmer should repeat after
> updating model from database!!!
You only need to correct SSDL, the rest will be there. And if you have
some source control, you can easily merge it.
> It's not seriously. It's not a wokk - it's a hell. This is real reason
> why we choose MSSQL instead of firebird.
This isn't question of MS SQL vs. Firebird. For same views, both behave same.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
