public static object ExecuteSqlScalar(Query command) { EnsureConnected(); command.Command.Connection = m_sqlConnection; return command.Command.ExecuteScalar(); }
public static void ExecuteSql(Query command, SqlCallback callback) { EnsureConnected(); command.Command.Connection = m_sqlConnection; var reader = command.Command.ExecuteReader(); callback(reader); reader.Close(); }
private List<RaidSignup> ReadAllHelper(Query query) { var newList = new List<RaidSignup>(); using (new ReaderLock(_lock)) { Connection.ExecuteSql(query, delegate(SqlDataReader reader) { while (reader.Read()) { var newRaidSignup = new RaidSignup { RaidInstanceID = (int)reader[0], Character = reader[1].ToString(), Comment = reader[2].ToString(), IsRostered = (bool)reader[3], IsCancelled = (bool)reader[4], RosteredSpecialization = (int)reader[5], SignupDate = (DateTime)reader[6] }; newList.Add(newRaidSignup); } }); } return newList.Count > 0 ? newList : null; }