Common.cs 1.2 KB

1234567891011121314151617181920212223242526272829303132
  1. using System;
  2. using System.Configuration;
  3. using System.Data;
  4. using System.Data.Common;
  5. using System.Web;
  6. public class Common
  7. {
  8. public static DbConnection CreateConnection(HttpRequest request)
  9. {
  10. string providerName = request.QueryString["provider"];
  11. if (providerName == null) {
  12. throw new ApplicationException("Missing provider querystring argument");
  13. }
  14. ConnectionStringSettings connectionSettings = ConfigurationManager.ConnectionStrings[providerName];
  15. DbProviderFactory factory = DbProviderFactories.GetFactory(connectionSettings.ProviderName);
  16. DbConnection connection = factory.CreateConnection();
  17. connection.ConnectionString = connectionSettings.ConnectionString;
  18. return connection;
  19. }
  20. public static int GetQueries(HttpRequest request) {
  21. int queries = 1;
  22. string queriesString = request.QueryString["queries"];
  23. if (queriesString != null) {
  24. // If this fails to parse, queries will be set to zero.
  25. int.TryParse(queriesString, out queries);
  26. queries = Math.Max(1, Math.Min(500, queries));
  27. }
  28. return queries;
  29. }
  30. }