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; }