1234567891011121314151617181920212223242526272829303132 |
- using System;
- using System.Configuration;
- using System.Data;
- using System.Data.Common;
- using System.Web;
- public class Common
- {
- public static DbConnection CreateConnection(HttpRequest request)
- {
- string providerName = request.QueryString["provider"];
- if (providerName == null) {
- throw new ApplicationException("Missing provider querystring argument");
- }
- ConnectionStringSettings connectionSettings = ConfigurationManager.ConnectionStrings[providerName];
- DbProviderFactory factory = DbProviderFactories.GetFactory(connectionSettings.ProviderName);
- DbConnection connection = factory.CreateConnection();
- connection.ConnectionString = connectionSettings.ConnectionString;
- return connection;
- }
- public static int GetQueries(HttpRequest request) {
- int queries = 1;
- string queriesString = request.QueryString["queries"];
- if (queriesString != null) {
- // If this fails to parse, queries will be set to zero.
- int.TryParse(queriesString, out queries);
- queries = Math.Max(1, Math.Min(500, queries));
- }
- return queries;
- }
- }
|