How to implement Idatareader and idataAdaptor methods ?

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Configuration;

using Microsoft.Practices.EnterpriseLibrary.Data;

using Microsoft.Practices.EnterpriseLibrary.Common;

using System.Data.SqlClient;

namespace CF.OpenAPI.DBFacade

{

public class MSSqlDatabase : IDatabase

{

private Database _database;

public Database ConcreteDatabase

{

get { return _database; }

set { _database = value; }

}

///

/// Configuration key that defines the database connection string.

///

public MSSqlDatabase(String key)

{

this.ConcreteDatabase = DatabaseFactory.CreateDatabase(key);

}

public System.Data.IDataReader DoReaderQuery(string query, Dictionary paramcoll)

{

string sql = query;

IDbConnection Connection;

//IDbCommand cmd = Connection.CreateCommand();

IDbCommand cmd = Connection.CreateCommand();

cmd.CommandText = sql;

cmd.CommandType = CommandType.Text;

IDbDataParameter p = cmd.CreateParameter();

p.ParameterName = "";

p.DbType = DbType.String;

p.Value = paramcoll;

cmd.Parameters.Add(p);

IDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));

}

reader.Close();

return reader;

// throw new NotImplementedException();

}

public System.Data.IDataAdapter DoAdapterQuery(string query)

{

using (IDbConnection connection = new SqlConnection(query))

{

connection.OpenAsync();

IDbCommand command = connection.CreateCommand();

command.CommandText = query;

using (IDataReader reader = command.ExecuteReaderAsync()

{

while (reader.ReadAsync())

{

if (!reader.IsDBNullAsync(0))

{

var name = reader.GetFieldValueAsync(0);

Assert.IsNotNull(name);

}

} while (reader.NextResultAsync());

}