How do I change the schema that the model wants to use to create the tables?
I am not using PostgreSQL for this, I am using Linq to SQL with Entity Developer professional and I am attempting to do Model first, I want to change the schema that the Model wants in order to create the tables. Is there any step by step on how to do Model first with Entity Developer?
How to change the schema that the model uses?
-
OutOfTouch6947
- Posts: 79
- Joined: Tue 02 Jun 2015 18:22
How to change the schema that the model uses?
Last edited by OutOfTouch6947 on Tue 19 Jan 2016 15:18, edited 2 times in total.
Re: How to change the schema that the model uses?
You are working with PostgreSQL via Entity Framework, aren't you?
You can control the shema name used in two ways:
1. Open your model, navigate to Tools > Entity Developer > Database Explorer, right click connection > Edit and set the Schema connection string parameter.
2. Navigate to Tools > Entity Developer > Model Explorer > Store part > Tables/Views and modify the Schema property specified for the tables. JIC: you can select several tables holding CTRL or SHIFT and modify (or clear) the Schema property for all tables simultaneously.
You can control the shema name used in two ways:
1. Open your model, navigate to Tools > Entity Developer > Database Explorer, right click connection > Edit and set the Schema connection string parameter.
2. Navigate to Tools > Entity Developer > Model Explorer > Store part > Tables/Views and modify the Schema property specified for the tables. JIC: you can select several tables holding CTRL or SHIFT and modify (or clear) the Schema property for all tables simultaneously.
-
OutOfTouch6947
- Posts: 79
- Joined: Tue 02 Jun 2015 18:22
Re: How to change the schema that the model uses?
No I am not, please see my updated question.Shalex wrote:You are working with PostgreSQL via Entity Framework, aren't you?
You can control the shema name used in two ways:
1. Open your model, navigate to Tools > Entity Developer > Database Explorer, right click connection > Edit and set the Schema connection string parameter.
2. Navigate to Tools > Entity Developer > Model Explorer > Store part > Tables/Views and modify the Schema property specified for the tables. JIC: you can select several tables holding CTRL or SHIFT and modify (or clear) the Schema property for all tables simultaneously.
-
OutOfTouch6947
- Posts: 79
- Joined: Tue 02 Jun 2015 18:22
Re: How to change the schema that the model uses?
Ok I think I found it under Model Settings -> Mapping -> Target Schema.Shalex wrote:You are working with PostgreSQL via Entity Framework, aren't you?
You can control the shema name used in two ways:
1. Open your model, navigate to Tools > Entity Developer > Database Explorer, right click connection > Edit and set the Schema connection string parameter.
2. Navigate to Tools > Entity Developer > Model Explorer > Store part > Tables/Views and modify the Schema property specified for the tables. JIC: you can select several tables holding CTRL or SHIFT and modify (or clear) the Schema property for all tables simultaneously.
Re: How to change the schema that the model uses?
Glad to see that the issue was resolved. If you encounter any issues with it, feel free to contact us.OutOfTouch6947 wrote:Ok I think I found it under Model Settings -> Mapping -> Target Schema.