Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var s = @"metadata=res://*/ProcurementModel.csdl|res://*/ProcurementModel.ssdl|
- res://*/ProcurementModel.msl;provider=System.Data.SqlClient;
- provider connection string=&';data source=JAMES-DESKTOPSQLEXPRESS;initial catalog=MyDatabase;persist security info=True;user id=User;password=*****;MultipleActiveResultSets=True;App=EntityFramework&';";
- public ProcurementContext()
- {
- var s =
- @"metadata=res://*/ProcurementModel.csdl|res://*/ProcurementModel.ssdl|
- res://*/ProcurementModel.msl;provider=System.Data.SqlClient;
- provider connection string=&';data source=JAMES-DESKTOPSQLEXPRESS;initial catalog=MyDatabase;persist security info=True;user id=jd;password=P@ssw0rd;MultipleActiveResultSets=True;App=EntityFramework&';";
- _connectionString = s;
- }
- public List<Procurement> ParcelListByUser(string userName)
- {
- using (var context = new ProcurementEntities(_connectionString))
- {
- return context.Procurements.Where(p => p.UserName == userName).ToList();
- }
- }
- public ProcurementEntities(string connectionString)
- : base(connectionString)
- {
- }
- public class ProcurementConfiguration:DbConfiguration
- {
- public ProcurementConfiguration()
- {
- SetExecutionStrategy("System.Data.SqlClient", () => new SqlAzureExecutionStrategy());
- SetDefaultConnectionFactory(new SqlConnectionFactory(ConnectionStrings.LocalConnectionString));
- }
- }
- public static string GetConnectionString()
- {
- // Build the provider connection string with configurable settings
- string cn = "server=" + mdlImpostazioni.p.dbServer;
- cn += ";database=" + mdlImpostazioni.p.dbName;
- cn += ";uid=" + mdlImpostazioni.p.dbUser;
- cn += ";pwd=" + mdlImpostazioni.p.dbPassword + ";";
- var providerSB = new SqlConnectionStringBuilder(cn);
- var efConnection = new EntityConnectionStringBuilder();
- // or the config file based connection without provider connection string
- efConnection.Provider = "System.Data.SqlClient";
- efConnection.ProviderConnectionString = providerSB.ConnectionString;
- // based on whether you choose to supply the app.config connection string to the constructor
- efConnection.Metadata = @"res://*"; //-----> very important
- return efConnection.ToString();
- }
- public partial class Entities : DbContext
- {
- public Entities(string nameOrConnectionString)
- : base(nameOrConnectionString)
- {
- }
- public void Close()
- {
- this.Dispose();
- }
- }
- myDbContext.Database.Connection.ConnectionString = "Data source=JAMES-DESKTOPSQLEXPRESS;initial catalog=MyDatabase;persist security info=True;user id=DynamicUser;password=DynamicPassword;MultipleActiveResultSets=True;App=EntityFrameworkForUser";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement