Esempi in C# (CSharp) per Joinery.Data Executer

Esempio n. 1

 public static Grouped <T> SelectAllGroupedBy <T>(string sql, Func <T, int> groupId, params object[] parameters) where T : new()
 {
     return(new Grouped <T>(Executer.ExecuteReader <T>(sql, parameters), groupId));
 }

Esempio n. 2

 public static T[] SelectAll <T>(string sql, params object[] parameters) where T : new()
 {
     return(Executer.ExecuteReader <T>(sql, parameters).ToArray());
 }

Esempio n. 3

 public static int ExecuteAll <T>(string sql, params object[] parameters)
 {
     return(Executer.ExecuteNonQuery <T>(sql, parameters));
 }

Esempio n. 4

 public static int ExecuteInt <T>(string sql, params object[] parameters)
 {
     return(Convert.ToInt32(Executer.ExecuteScalar <T>(sql, parameters)));
 }

Esempio n. 5

 public static T SelectFirst <T>(string sql, params object[] parameters) where T : new()
 {
     return(Executer.ExecuteReader <T>(sql, parameters).FirstOrDefault());
 }