WPF: Datenbank Connection ändern zur Laufzeit
Aufgabe: Ändern der Datenbank Verbindung zu Laufzeit in einer WPF Datenbank Anwendung
..Lösung offen
Betrifft: WPF, Connection, SQLString, SQL anbindung
Den Standard-Connectionstring findet man in der App.config
<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </configSections> <connectionStrings> <add name="Schichtplaner.Properties.Settings.DB_SchichtplanerConnectionString" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\DB_Schichtplaner.mdf;Integrated Security=True" providerName="System.Data.SqlClient" /> <add name="dbConnectionString" connectionString="metadata=res://*/dbModel.csdl|res://*/dbModel.ssdl|res://*/dbModel.msl;provider=System.Data.SqlClient; provider connection string="data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\DB_Schichtplaner.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /> </connectionStrings> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.1" /> </startup> <entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> <providers> <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> </providers> </entityFramework> </configuration>
|
Aktuell in der Datenbank Model
//------------------------------------------------------------------------------ // <auto-generated> // This code was generated from a template. // // Manual changes to this file may cause unexpected behavior in your application. // Manual changes to this file will be overwritten if the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------
namespace Schichtplaner { using System; using System.Data.Entity; using System.Data.Entity.Infrastructure;
public partial class dbConnectionString : DbContext { public dbConnectionString() : base("name=dbConnectionString") { this.Configuration.LazyLoadingEnabled = false; }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); }
public virtual DbSet<tblBase_Abwesenheitsgruende> tblBase_Abwesenheitsgruende { get; set; } public virtual DbSet<tblBase_Feiertage> tblBase_Feiertage { get; set; } public virtual DbSet<tblBase_Maschinen> tblBase_Maschinen { get; set; } public virtual DbSet<tblBase_Maschinengruppen> tblBase_Maschinengruppen { get; set; } public virtual DbSet<tblBase_Mitarbeiter> tblBase_Mitarbeiter { get; set; } public virtual DbSet<tblBase_Mitarbeitergruppen> tblBase_Mitarbeitergruppen { get; set; } public virtual DbSet<tblBase_Schichten> tblBase_Schichten { get; set; } public virtual DbSet<tblBase_Schichtgruppen> tblBase_Schichtgruppen { get; set; } public virtual DbSet<tbl_Schichtplan> tbl_Schichtplan { get; set; } } }
|