Torna al Thread
//Imposto la stringa del provider desiderato, in questo cosa SqlServer.
var sqlConnString = new SqlConnectionStringBuilder();
sqlConnString.DataSource = "192.168.1.XX";
sqlConnString.InitialCatalog = "IMS";
sqlConnString.UserID = "TuoUsername";
sqlConnString.Password = "TuaPassword";
sqlConnString.MultipleActiveResultSets = true;
//Creo la stringa di connessione dell'entity framework inserendo i file csdl,ssdl,msl,impostando il provider di connessione ( SqlClient ) e impostando //nella proprietà ProviderConnectionString la connectionstring di SqlServer creata precedentemente.
var entityConnString = new EntityConnectionStringBuilder();
entityConnString.Metadata = "res://*/IMS.csdl|res://*/IMS.ssdl|res://*/IMS.msl";
entityConnStringr.Provider = "System.Data.SqlClient";
entityConnString.ProviderConnectionString = sqlConnString.ConnectionString;
//Inizializzo il datamodel impostando come stringa di connessione la proprietà ConnectionString dell'istanza entityConnString
//EntityConnectionStringBuilder
IMSEntities Model = new IMSEntities(builder.ConnectionString);