Metadata issue in Entity Framework connection string

Question

I have a Silverlight 4 application using RIA services in which I moved all the code related to RIA services to a separate module (WCF RIA Services class library) called "AppServices". Call the main Silverlight4App application. I need to authenticate users from a different database except the database where the rest of the data is stored. I added an EF model to AppServices.Web, which also houses the authentication service. The Web.config file is located in the main application, that is, in Silverlight4App.

In the connectionStrings section of the web.config file, I originally had this:

<add name="AuthEntities" connectionString="metadata=res://*/AuthModel.csdl|res://*/AuthModel.ssdl|res://*/AuthModel.msl;provider=... />

and I got the following error:

"Download failed for GetUser request. Unable to load the specified metadata resource."

Then I tried various things, such as:

<add name="AuthEntities" connectionString="metadata=..\..\bin\AuthModel.csdl|..\..\bin\AuthModel.ssdl|..\..\bin\AuthModel.msl;provider=... />

and got this error:

"Download failed for GetUser request. The specified metadata path is invalid. The valid path must be either an existing directory or an existing file with the extension" .csdl ",". Ssdl ", or" .msl 'or URI that identifies the embedded resource. "

I also tried copying metadata files to different locations. In the end, I got a little more with the following.

<add name="AuthEntities" connectionString="metadata=~\..\..\..\Silverlight4App.Web\Metadata\AuthModel.csdl|~\..\..\..\Silverlight4App.Web\Metadata\AuthModel.ssdl|~\..\..\..\Silverlight4App.Web\Metadata\AuthModel.msl;provider=... />

With the above connection string, I got the following error:

" " GetUser ". , .\r\n: connectionString : .NET .

, , , ! - , , :

<add name="AuthEntities" connectionString="metadata=C:\Users\...\Silverlight4App.Web\Metadata\AuthModel.csdl|C:\Users\...\Silverlight4App.Web\Metadata\AuthModel.ssdl|C:\Users\...\Silverlight4App.Web\Metadata\AuthModel.msl;provider=... />

! , , .

, , (. ), , , , , , , , , ...

? - !

Answer 1

Reflector, , ; , . , - ; , . , , , ( - ).

Answer 2

: Environment.CurrentDirectory. - , , EXE. - .

. edmx EntityDeploy. ilasm reflector , , / ...

Answer 3

- factory EF. factory edmxconnection, : ( VB)

Public Shared Function GetEDMXConnectionString(Of T As ObjectContext)(Optional ByVal connectionString As String = "") As EntityConnection
  Dim dbConnection As New SqlConnection(connectionString)
  Dim resourceArray As String() = {"res://*/"}
  Dim assemblyList As Assembly() = {GetType(T).Assembly}
  Dim metaData As New MetadataWorkspace(resourceArray, assemblyList)
  Dim edmxConnection As New EntityConnection(metaData, dbConnection)

  Return edmxConnection
End Function

Context .