using System;

using System.Collections.Generic;

using System.Data;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

}

​

    public interface IUnitOfWork : IDisposable

    {

        void Rollback();

​

        IDb Db { get; }

    }

    public interface IDatabaseRepository

    {

        IDbFactory DbFactory { get; }

    }

    public interface IDbFactory

    {

        IUnitOfWork CreateUnitOfWork();

​

        IDb CreateConnection();

​

        //IDb CreateConnection(ITransaction transaction, IDbConnection connection); -- nhibernate transaction

    }

​

public interface IDb

    {

        string ConnectionString { get; set; }

​

        IDbConnection Connection { get; }

​

        IEnumerable<string> Tables { get; }

        // Reads a single set of data and populates new business object instances with the data

        IEnumerable<T> Read<T>(string sql, Func<IDataReader, T> make, params object[] parms);

        // Reads a single set of data and populates the supplied business object with the data - excludes primary keys as these are already present        

        T Read<T>(string sql, Func<IDataReader, T, T> makeFrom, T businessObject, params object[] parms);

​

        IEnumerable<dynamic> Query(string sql, params object[] parms);

        void Execute(string sql, params object[] parms);

        object Scalar(string sql, params object[] parms);

        int Insert(string sql, params object[] parms);

​

        int Update(string sql, params object[] parms);

        int Delete(string sql, params object[] parms);

         void BeginTransaction();

        void EndTransaction();

​

        void RollbackTransaction();

    }