Using the Entity Framework with multiple SQL Server schemas
Using the Entity Framework with multiple SQL Server schemas: keywords: multiple schemas, entity database schemas .dbo. Other schemas than .dbo.
I have heard (and read) much feedback about using SQL Server (2012) schemas with the ADO Entity Framework model. Some say you cannot use anything BUT .dbo in the Entity model, while other suggest you can. An example would be if you wanted to point the Entity model builder at a SQL Server database that has tables in 3 schemas: Sales, Products, Vendors.
Can someone give me definitive advice on this matter. It seems there is a lot of contradictory posts out on the web. Thank you.