Implementing Model-View-Presenter in ASP.NET

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

using MySql.Data.MySqlClient;

namespace SubSonic
{
    public class MySqlInnoDBDataProvider : MySqlDataProvider
    {
        public override string GetForeignKeyTableName(string fkColumnName)
        {
            string tableName = string.Empty;

            if(SupportsInformationSchema(GetDatabaseVersion(Name)))
            {
                string sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE COLUMN_NAME = ?ColumnName AND CONSTRAINT_NAME = 'PRIMARY' AND TABLE_SCHEMA = ?DatabaseName";

                using (AutomaticConnectionScope automaticConnectionScope = new AutomaticConnectionScope(this))
                {
                    MySqlCommand cmd = new MySqlCommand(sql);
                    cmd.CommandType = CommandType.Text;
                    cmd.Connection = (MySqlConnection)automaticConnectionScope.Connection;

                    cmd.Parameters.AddWithValue("?ColumnName", fkColumnName);
                    cmd.Parameters.AddWithValue("?DatabaseName", cmd.Connection.Database);

                    object result = cmd.ExecuteScalar();
                    if (result != null)
                    {
                        tableName = result.ToString();
                    }
                }
            }

            return tableName;
        }

        public override string GetForeignKeyTableName(string fkColumnName, string tableName)
        {
            string returnTableName = string.Empty;

            if (SupportsInformationSchema(GetDatabaseVersion(Name)))
            {
                string sql = "SELECT REFERENCED_TABLE_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE COLUMN_NAME = ?ColumnName AND TABLE_NAME = ?TableName AND TABLE_SCHEMA = ?DatabaseName";

                using (AutomaticConnectionScope automaticConnectionScope = new AutomaticConnectionScope(this))
                {
                    MySqlCommand cmd = new MySqlCommand(sql);
                    cmd.CommandType = CommandType.Text;
                    cmd.Connection = (MySqlConnection)automaticConnectionScope.Connection;

                    cmd.Parameters.AddWithValue("?ColumnName", fkColumnName);
                    cmd.Parameters.AddWithValue("?TableName", tableName);
                    cmd.Parameters.AddWithValue("?DatabaseName", cmd.Connection.Database);

                    object result = cmd.ExecuteScalar();
                    if (result != null)
                    {
                        returnTableName = result.ToString();
                    }
                }
            }

            return returnTableName;
        }
    }
}