internal void Execute(string query) { using IConnectionWrapper conn = dbWrapper.CreateConnection(); conn.Open(); using ICommandWrapper comm = dbWrapper.CreateCommand(query.ToString()); comm.ExecuteNonQuery(); }
internal List <T> ExecuteAndReadEntity <T>(string query) where T : new() { using IConnectionWrapper conn = dbWrapper.CreateConnection(); conn.Open(); using ICommandWrapper comm = dbWrapper.CreateCommand(query); var entities = comm.ExecuteReaderEntity <T>(); return(entities); }
internal List <T> ExecuteAndReadOneColumn <T>(string query) { using IConnectionWrapper conn = dbWrapper.CreateConnection(); conn.Open(); using ICommandWrapper comm = dbWrapper.CreateCommand(query); var entities = comm.ExecuteReaderOneColumn <T>(0); return(entities); }