Version2, C#, Newest, Self Serving

We have updateable views which are 1:1 based on tables in other DBs in the same server.

Is it possible to create an 'entity' in the designer but that is based on a view instead of a table and so would give the same CRUD support? That would save us from creating multiple LLBL projects for each database.

Ian

It's possible to map a database view into an Entity.

Thanks Walaa,

Could you point me in the right direction/manual location where I can learn how to do that?

Ian

Manual's section "Using the designer -> Adding and editing entities"

Adding entities To add entities to your project you take the following steps: In the Project Explorer, right-click 'Entities' and choose 'Add New Entities Mapped On Tables From Catalog(s)'. You can also select 'Entities' and press Ctrl + T, or select 'Add New Entities Mapped On Tables From Catalog(s)' in the Project menu of the designer. This will allow you to add entities based on a table. If you want to add entities based on views, select 'Add New Entities Mapped On Views From Catalog(s)' instead (or press Ctrl + V)