Entities _context = (Entities)HttpContext.Current.Session[SessionNames.xContext];
using WebSession = System.Web.HttpContext;
#region Build Connection String Dynamically
public string BuildConnectionString(string dataSource, string database, string userId, string password)
{
// string connect = BuildConnectionString(dataSource,
custDbName, dbUserId, dbUserPassword);
EntityConnectionStringBuilder retval = new EntityConnectionStringBuilder();
//// Build the connection string from the provided
datasource and database
try
{
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder
{
DataSource = "x.x.x.x",
InitialCatalog = "xTemplate",
UserID = "x",
Password = "x",
IntegratedSecurity = false,
MultipleActiveResultSets = true
};
retval = new EntityConnectionStringBuilder
{
Metadata = "res://*/x.Client.csdl|res://*/x.Client.ssdl|res://*/x.Client.msl",
Provider = "System.Data.SqlClient",
ProviderConnectionString =
sqlBuilder.ToString()
};
BuildDatabaseContext(retval.ToString());
}
catch
(Exception e)
{
throw;
}
return retval.ToString();
}
public void BuildDatabaseContext(string connectionString)
{
try
{
StoreContext(connectionString);
}
catch
(Exception e)
{
throw;
}
}
public void StoreContext(string connect)
{
try
{
Entities context = new Entities(connect);
WebSession.Current.Session[SessionNames.xContext] = context;
}
catch
(Exception e)
{
throw;
}
}
#endregion