EntitySet schema value dbo instead of database.dbo

131 views Asked by At

Running EFProfiler found that the query running behind the scenes was

SELECT [Extent1].[Total] AS [Total]
FROM  [dbo].[Invoice] AS [Extent1]

The problem is that the DB name is incorrect. It should be:

SELECT [Extent1].[Total] AS [Total]
FROM  [Chinook].[dbo].[Invoice] AS [Extent1]

How do I change the syntax of entityset schema ?

<EntitySet Name="Invoice" EntityType="ChinookModel.Store.Invoice" store:Type="Tables" Schema="dbo" />

I have tried changing the schema to Chinook.dbo, but it does not work.

0

There are 0 answers