Entity Framework and SQL Server Synonyms

sql-server entity-framework synonym
ProfK picture ProfK · Dec 6, 2010 · Viewed 9.7k times · Source

Hasty research tells me that even EF4 still doesn't support SQL Server synonyms. What are my options for setting up a synonym based entity set as if it were a table based entity set? The crudest I have come up with is to copy the underlying table for the synonym, add it to my model, and then rename the entity set in the store model. Is there no more elegant workaround using the POCO or code-first approach?

Answer

Shiraz Bhaiji picture Shiraz Bhaiji · Feb 2, 2011

You could create a view that selects data from your synonym and then add the view to your model. Giving the view in your model the name of the synonym.

Related questions

Making an Entity Framework Model span multiple databases

Is it valid to do something such as CREATE SYNONYM [dbo].[MyTable] FOR [AnotherDatabase].dbo.[MyTable] and then modify Entity Framework's edmx file to read this object like it would any other table? I did a quick sample test and …

Read More
MSSQL Error 'The underlying provider failed on Open'

I was using an .mdf for connecting to a database and entityClient. Now I want to change the connection string so that there will be no .mdf file. Is the following connectionString correct? <connectionStrings> <!--<add …

Read More
Conversion of a datetime2 data type to a datetime data type results out-of-range value

I've got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction. While saving, an error is returned: The conversion of a datetime2 data type to a datetime data type …

Read More