public static SwiftDataReader ExecuteReader(string connectionString, string commandText, params DbParameter[] parameters)
{
var dataAccess = SwiftDataAccess.Create(connectionString);
dataAccess.SetCommand(commandText, CommandType.StoredProc, parameters);
return(dataAccess.ExecuteReader());
}
public static T ExecuteScalar <T>(string connectionString, string commandText, params DbParameter[] parameters)
{
var dataAccess = SwiftDataAccess.Create(connectionString);
dataAccess.SetCommand(commandText, CommandType.StoredProc, parameters);
var result = dataAccess.ExecuteScalar();
return(ConvertTo <T>(result));
}
public SwiftDataReader ExecuteReader()
{
SwiftDataAccess self = null;
connection.Open();
self = this;
return(new SwiftDataReader(command.ExecuteReader(), self));
}
public static T GetItem <T>(string connectionString, string commandText, params DbParameter[] parameters)
where T : IPersistent, new()
{
var dataAccess = SwiftDataAccess.Create(connectionString);
dataAccess.SetCommand(commandText, CommandType.StoredProc, parameters);
using (var reader = dataAccess.ExecuteReader())
{
if (reader.Read())
{
T item = new T();
item.Init(reader);
return(item);
}
}
return(default(T));
}
public static IEnumerable <T> GetPrimitivesList <T>(string connectionString, string commandText, params DbParameter[] parameters)
{
var dataAccess = SwiftDataAccess.Create(connectionString);
var list = new List <T>();
dataAccess.SetCommand(commandText, CommandType.StoredProc, parameters);
using (var reader = dataAccess.ExecuteReader())
{
while (reader.Read())
{
T item = (T)reader[0];
list.Add(item);
}
}
return(list);
}
public static IEnumerable <T> GetList <T>(string connectionString, string commandText, params DbParameter[] parameters)
where T : IPersistent, new()
{
var dataAccess = SwiftDataAccess.Create(connectionString);
List <T> list = new List <T>();
dataAccess.SetCommand(commandText, CommandType.StoredProc, parameters);
using (var reader = dataAccess.ExecuteReader())
{
while (reader.Read())
{
T item = new T();
item.Init(reader);
list.Add(item);
}
}
return(list);
}
public SwiftDataReader(SqlDataReader reader, SwiftDataAccess disposableParent)
{
this.reader = reader;
this.disposableParent = disposableParent;
}
