Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.75 KB | None | 0 0
  1. var s = @"metadata=res://*/ProcurementModel.csdl|res://*/ProcurementModel.ssdl|
  2. res://*/ProcurementModel.msl;provider=System.Data.SqlClient;
  3. provider connection string=&';data source=JAMES-DESKTOPSQLEXPRESS;initial catalog=MyDatabase;persist security info=True;user id=User;password=*****;MultipleActiveResultSets=True;App=EntityFramework&';";
  4.  
  5. public ProcurementContext()
  6. {
  7. var s =
  8. @"metadata=res://*/ProcurementModel.csdl|res://*/ProcurementModel.ssdl|
  9. res://*/ProcurementModel.msl;provider=System.Data.SqlClient;
  10. provider connection string=&';data source=JAMES-DESKTOPSQLEXPRESS;initial catalog=MyDatabase;persist security info=True;user id=jd;password=P@ssw0rd;MultipleActiveResultSets=True;App=EntityFramework&';";
  11.  
  12. _connectionString = s;
  13. }
  14.  
  15. public List<Procurement> ParcelListByUser(string userName)
  16. {
  17. using (var context = new ProcurementEntities(_connectionString))
  18. {
  19. return context.Procurements.Where(p => p.UserName == userName).ToList();
  20. }
  21. }
  22.  
  23. public ProcurementEntities(string connectionString)
  24. : base(connectionString)
  25. {
  26. }
  27.  
  28. public class ProcurementConfiguration:DbConfiguration
  29. {
  30. public ProcurementConfiguration()
  31. {
  32. SetExecutionStrategy("System.Data.SqlClient", () => new SqlAzureExecutionStrategy());
  33. SetDefaultConnectionFactory(new SqlConnectionFactory(ConnectionStrings.LocalConnectionString));
  34. }
  35. }
  36.  
  37. public static string GetConnectionString()
  38. {
  39. // Build the provider connection string with configurable settings
  40. string cn = "server=" + mdlImpostazioni.p.dbServer;
  41. cn += ";database=" + mdlImpostazioni.p.dbName;
  42. cn += ";uid=" + mdlImpostazioni.p.dbUser;
  43. cn += ";pwd=" + mdlImpostazioni.p.dbPassword + ";";
  44. var providerSB = new SqlConnectionStringBuilder(cn);
  45. var efConnection = new EntityConnectionStringBuilder();
  46. // or the config file based connection without provider connection string
  47. efConnection.Provider = "System.Data.SqlClient";
  48. efConnection.ProviderConnectionString = providerSB.ConnectionString;
  49. // based on whether you choose to supply the app.config connection string to the constructor
  50. efConnection.Metadata = @"res://*"; //-----> very important
  51. return efConnection.ToString();
  52. }
  53.  
  54. public partial class Entities : DbContext
  55. {
  56. public Entities(string nameOrConnectionString)
  57. : base(nameOrConnectionString)
  58. {
  59.  
  60. }
  61.  
  62. public void Close()
  63. {
  64. this.Dispose();
  65. }
  66. }
  67.  
  68. 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