Guest User

Untitled

a guest
Jun 18th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. Public Shared Function GetResultsByKeywords(ByVal key1 As String, ByVal key2 As String, ByVal key3 As String, ByVal key4 As String) As DataTable
  2. Dim db As SqlDatabase = New SqlDatabase(Connection.GetConnectString())
  3. Dim dt As DataTable = New DataTable
  4.  
  5. Using dr As IDataReader = db.ExecuteReader("sel_eHELP_ITEMS", key1, key2, key3, key4)
  6. dt.Load(dr)
  7. End Using
  8.  
  9. Return dt
  10. End Function
  11.  
  12. public class MyDAL
  13. {
  14. private string _connectionString;
  15.  
  16. public MyDAL(string connectionString)
  17. {
  18. _connectionString = connectionString;
  19. }
  20.  
  21. public int MyDatabaseCall()
  22. {
  23. using (SqlConnection conn = new SqlConnection(_connectionString))
  24. {
  25. using (SqlCommand cmd = new SqlCommand("my sql", conn))
  26. {
  27. conn.Open();
  28. using (SqlDataReader reader = cmd.ExecuteReader())
  29. {
  30. //...data access
  31. return 0;
  32. }
  33. }
  34. }
  35. }
  36. }
  37.  
  38. public class MyApp
  39. {
  40. public static Dictionary<string, MyDAL> myDatabases = new Dictionary<string, MyDAL>();
  41.  
  42. public string GetConnectionString(string database)
  43. {
  44. return System.Configuration.ConfigurationManager.ConnectionStrings[database].ConnectionString;
  45. }
  46.  
  47. public void StartUp() // Global.asax Application_Start ?
  48. {
  49. myDatabases.Add("Database1", new MyDAL(GetConnectionString("Database1")));
  50. myDatabases.Add("Database2", new MyDAL(GetConnectionString("Database2")));
  51. myDatabases.Add("Database3", new MyDAL(GetConnectionString("Database3")));
  52. }
  53.  
  54. public MyDAL DataAcccessLayer
  55. {
  56. get
  57. {
  58. string usersDB = FigureOutUsersDatabase();
  59. return myDatabases[usersDB];
  60. }
  61. }
  62.  
  63. public void UseSomeData()
  64. {
  65. var myData = DataAcccessLayer.MyDatabaseCall();
  66. //Do Stuff
  67. }
  68. }
Add Comment
Please, Sign In to add comment