Entity - problems retrieving database model
-
Hello all! Yesterday I installed the Entity Framework on my machine because I want to give it a test run. I started with the quick start guide from MSDN, by creating a database on my SQLServer 2008. I stumbled upon a problem when trying to retrieve the database information for the entity model. The connection is OK, but there an error message coming up when it tries to get the details. This is the message:
"An error occured while connection to the database. The database may be unavailable. The error message is: 'CatalogName' is not a member of type 'Provider.Table' in currently loaded schemas, near multipart identifier, line 3, column 17."
This is the connection string it generates:
metadata=res://*/EntityTest.csdl|res://*/EntityTest.ssdl|res://*/EntityTest.msl;provider=System.Data.SqlClient;provider connection string="Data Source=GAGEANU-M-MOBIL;Initial
Catalog=School;Integrated Security=True;User Instance=False"I use Windows Authentification on SQLServer 2008, with the default settings. I googled the problem but found no answer. I would appreciate it if you could help me with this. :) Thanks.