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 + "\""); } }