DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuide.
Windows Authentication is used.
To obtain data from PassGuideDB the ADO .NET Entity Framework is used.
In the file PassGuide.Data.dll the three files (model.csdl, model.ssdl, and model.msi)
embedded as resources using EDM. You need to specify the connection string, stored in
app.config, for PassGuideApp.
Answer: 
Explanation:
The specified answer does not seem completely correct. After a lot of googling here’s what I came up with:
1) connectionString = ‘metadata=xyz://PassGuide.Data’
2) Culture = neutral, pretty obvious
3) provider = ???
4) providerName = “Ssytem.Data.EntityClient”
All, but the 3rd answer are pretty obvious. Now the suggested answer is:
3) provider=”System.Data.EntityClient;provider connection string = ‘DataSoruce=localhost;’
but after a lot of googling, I never saw a connection string using that combination. In fact all cases were using:
3) provider=”System.Data.SqlClient;provider connection string = ‘DataSoruce=localhost;’
And that is the answer I’ll be sticking with. See the following link for details:
http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnection.connectionstring%28v=vs.110%29.aspx
Here’s the conneciton string suggested by Micorsoft, note that they use SqlClient as I suggested:
(… apparently this forum strips xml code, so you’ll have to go to the link specified to see the connection string)
Yes, the provider should be System.Data.SqlClient
and providerName to be System.Data.EntityClient