This is an example of a custom request handler that retrieves the database connection string from Web.config.

This example is for ASP.NET and not for ASP.NET Core. ASP.NET Core projects use a appsettings.json file instead of Web.config

using System;

using System.Configuration;

using System.Data.SqlClient;

using Ventura;

using VenturaServer;

namespace AspNetServer


    public class CustomRequestHandler : IVenturaRequestHandler


        public void Authenticate(bool is_secure_connection, string username, string password, string databag)


            if (is_secure_connection == false) // SSL is obligated

                throw new Exception("Authentication is not allowed over an open (non-SSL) connection.");

            if (username != "admin" || password != "password")

                throw new Exception("Incorrect username and/or password.");


        public AdoConnector LookupAdoConnector(string remote_connector_name)


            // Read the connection string from Web.config

            ConnectionStringSettings css = ConfigurationManager.ConnectionStrings["DefaultConnection"];

            if (css == null)

                throw new Exception("Connection string 'DefaultConnection' not found in Web.config");

            return new AdoConnector(SqlClientFactory.Instance, css.ConnectionString);




An example of a Web.config with the DefaultConnection entry in it:

<?xml version="1.0" encoding="utf-8"?>



    <add name="DefaultConnection" connectionString="Server=(local);Initial Catalog=AdventureWorks2017;Integrated Security=SSPI;Max Pool Size=250;Connect Timeout=30;" providerName="System.Data.SqlClient" />