public void LoadContext()
{
System.Data.EntityClient.EntityConnectionStringBuilder connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder()
{
Metadata = "res://*/DataModel1.csdl|res://*/DataModel1.ssdl|res://*/DataModel1.msl",
Provider = "System.Data.SqlClient",
ProviderConnectionString = sageSession1.GetConnectionString()
};
conection = connectionString.ToString();
mycontext = new Sage500AppEntities(connectionString.ToString());
}
/// <summary>
/// </summary>
public static ItemEntities Instance()
{
var entityBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
entityBuilder.ProviderConnectionString = DotNetNuke.Common.Utilities.Config.GetConnectionString();
entityBuilder.Metadata = "res://*/";
entityBuilder.Provider = "System.Data.SqlClient";
return(new ItemEntities(entityBuilder.ToString()));
}
void CreateObjectContextIfNull()
{
if (objectContext != null)
{
return;
}
System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
builder.ProviderConnectionString = ServerModeOptions.SQLConnectionString;
builder.Metadata = @"res://*/Controls.EFServerModeModel.csdl|res://*/Controls.EFServerModeModel.ssdl|res://*/Controls.EFServerModeModel.msl";
builder.Provider = "System.Data.SqlClient";
DataContext = objectContext = new DXGridServerModeDBEntities(builder.ToString());
}
private static string GetEntityConnectionString(string password)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["fichario"].ConnectionString;
System.Data.EntityClient.EntityConnectionStringBuilder entityconnection = new System.Data.EntityClient.EntityConnectionStringBuilder(s);
//EntityConnectionStringBuilder inherits from DBConnectionStringBuilder
//so you should be able to replace the password simply
entityconnection["Password"] = password;
//otherwise, if you know the connection properties you need
//you could rebuild an entity connection object.
return(entityconnection.ToString());
}
private void CopyServiceFiles()
{
Assembly resourceAssembly = this.GetType().Assembly;
IOUtil.EnsureDirectoryExists(DestinationFolder);
IOUtil.EmptyDirectoryRecusively(DestinationFolder);
string serviceSourceCodePath = Path.Combine(DestinationFolder, _serviceName + ".cs");
StringBuilder serviceSource = new StringBuilder();
serviceSource.AppendLine(this.Workspace.BuildDataServiceClassUsings());
serviceSource.AppendLine("namespace CustomTestServiceHost");
serviceSource.AppendLine("{");
serviceSource.AppendLine(this.Workspace.BuildDataServiceClassCode());
serviceSource.AppendLine("}");
File.WriteAllText(serviceSourceCodePath, serviceSource.ToString());
this.Workspace.PopulateHostSourceFolder();
// copy additional files
foreach (string file in this.Workspace.ServiceHostFiles())
{
File.Copy(file, Path.Combine(DestinationFolder, Path.GetFileName(file)));
if (file.Contains("Edm.ObjectLayer"))
{
string copiedFile = Path.Combine(DestinationFolder, Path.GetFileName(file));
string fileText = File.ReadAllText(copiedFile);
string pathAndName = Path.Combine(DestinationFolder, this.Workspace.Name);
System.Data.EntityClient.EntityConnectionStringBuilder connBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
connBuilder.ProviderConnectionString = this.Workspace.Database.DatabaseConnectionString;
connBuilder.Metadata = pathAndName + ".csdl|" + pathAndName + ".ssdl|" + pathAndName + ".msl";
connBuilder.Provider = "System.Data.SqlClient";
string connString = connBuilder.ToString();
connString = connString.Replace(@"\", @"\\");
connString = connString.Replace("\"", "\\\"");
string modifiedText = fileText.Replace("name=" + this.Workspace.ContextTypeName, connString);
File.WriteAllText(copiedFile, modifiedText);
}
}
#if false // pulled from GAC - not local filesystem
// Copy Microsoft.OData.Service.dll and test framework
if (!AstoriaTestProperties.SetupRunOnWebServer)
{
if (AstoriaTestProperties.Host != Host.Debug)
{
File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
}
else
{
File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
}
if (AstoriaTestProperties.Host != Host.Debug)
{
File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
}
else
{
File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
}
}
#endif
// TODO: cannot get rid of framework DLL for client SKU
// File.Copy(resourceAssembly.Location, Path.Combine(hostFolder, Path.GetFileName(resourceAssembly.Location)));
CopyServerWorkspaceFiles(DestinationFolder);
}
private void CopyServiceFiles()
{
Assembly resourceAssembly = this.GetType().Assembly;
IOUtil.EnsureDirectoryExists(DestinationFolder);
IOUtil.EmptyDirectoryRecusively(DestinationFolder);
string serviceSourceCodePath = Path.Combine(DestinationFolder, _serviceName + ".cs");
StringBuilder serviceSource = new StringBuilder();
serviceSource.AppendLine(this.Workspace.BuildDataServiceClassUsings());
serviceSource.AppendLine("namespace CustomTestServiceHost");
serviceSource.AppendLine("{");
serviceSource.AppendLine(this.Workspace.BuildDataServiceClassCode());
serviceSource.AppendLine("}");
File.WriteAllText(serviceSourceCodePath, serviceSource.ToString());
this.Workspace.PopulateHostSourceFolder();
// copy additional files
foreach (string file in this.Workspace.ServiceHostFiles())
{
File.Copy(file, Path.Combine(DestinationFolder, Path.GetFileName(file)));
if (file.Contains("Edm.ObjectLayer"))
{
string copiedFile = Path.Combine(DestinationFolder, Path.GetFileName(file));
string fileText = File.ReadAllText(copiedFile);
string pathAndName = Path.Combine(DestinationFolder, this.Workspace.Name);
System.Data.EntityClient.EntityConnectionStringBuilder connBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
connBuilder.ProviderConnectionString = this.Workspace.Database.DatabaseConnectionString;
connBuilder.Metadata = pathAndName + ".csdl|" + pathAndName + ".ssdl|" + pathAndName + ".msl";
connBuilder.Provider = "System.Data.SqlClient";
string connString = connBuilder.ToString();
connString = connString.Replace(@"\", @"\\");
connString = connString.Replace("\"", "\\\"");
string modifiedText = fileText.Replace("name=" + this.Workspace.ContextTypeName, connString);
File.WriteAllText(copiedFile, modifiedText);
}
}
#if false // pulled from GAC - not local filesystem
// Copy Microsoft.OData.Service.dll and test framework
if (!AstoriaTestProperties.SetupRunOnWebServer)
{
if (AstoriaTestProperties.Host != Host.Debug)
File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
else
File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
if (AstoriaTestProperties.Host != Host.Debug)
File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
else
File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
}
#endif
// TODO: cannot get rid of framework DLL for client SKU
// File.Copy(resourceAssembly.Location, Path.Combine(hostFolder, Path.GetFileName(resourceAssembly.Location)));
CopyServerWorkspaceFiles(DestinationFolder);
}
/// <summary>
/// Builds a Connection String that's usable by EntityFramework.
/// SetConnectionString must be called before (if not, DefaultConnectionStringName is used).
/// ConnectionString must be a simple SQL Connection string (not a Entity Framework one).
/// </summary>
/// <returns>ConnectionString for the EntityFramework</returns>
internal static string GetConnectionString()
{
if (!string.IsNullOrEmpty(_connectionStringName))
{
//string ConnectionStringName = HttpContext.Current.Application[AppSettingPrefix + "." + ConnectionStringSetting].ToString();
var connectionStringName = _connectionStringName;
var builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
try
{
builder.ProviderConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString;
}
catch (NullReferenceException)
{
throw new Exception("Couldn't load Connection String with name \"" + connectionStringName + "\"");
}
if (!builder.ProviderConnectionString.Contains("MultipleActiveResultSets"))
builder.ProviderConnectionString += ";MultipleActiveResultSets=True";
builder.Metadata = "res://*/Persistence.EavContext.csdl|res://*/Persistence.EavContext.ssdl|res://*/Persistence.EavContext.msl";
builder.Provider = "System.Data.SqlClient";
return builder.ToString();
}
try
{
return System.Configuration.ConfigurationManager.ConnectionStrings[DefaultConnectionStringName].ConnectionString;
}
catch (NullReferenceException)
{
throw new Exception("Couldn't load Connection String with name \"" + DefaultConnectionStringName + "\"");
}
}
