public static void Read() { var a = DbConnector.Query("SELECT * FROM USERS"); foreach (var x in a) { Console.WriteLine(x["FirstName"]); } }
static void Read() { Console.Clear(); List <Dictionary <string, object> > users = DbConnector.Query("SELECT * FROM table1"); foreach (var user in users) { System.Console.WriteLine(user["id"] + " " + user["first_name"] + " " + user["last_name"] + " " + user["favorite_number"]); } }
public static void Read() { List <Dictionary <string, object> > users = DbConnector.Query("SELECT * FROM users"); foreach (var user in users) { Console.WriteLine($"First Name: {user["first_name"]}"); Console.WriteLine($"Last Name: {user["last_name"]}"); Console.WriteLine($"Favorite Number: {user["favorite_number"]}"); Console.WriteLine($"Date Created: {user["created_at"]}"); System.Console.WriteLine("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"); } }
// public static List<Dictionary<string, object>> Users = DbConnector.Query("SELECT * FROM users"); public static void Read() { List <Dictionary <string, object> > Users = DbConnector.Query("SELECT * FROM users"); var names = Users.ToList(); foreach (var name in names) { foreach (KeyValuePair <string, object> inner in name) { Console.WriteLine(inner.Key + " " + inner.Value); } } }
public static void Update(int id, string q1 = "", string q2 = "", string q3 = "") { List <Dictionary <string, object> > user = DbConnector.Query($"SELECT * FROM users WHERE user_id = {id}"); Console.WriteLine("User " + user[0]["FirstName"] + " " + user[0]["LastName"] + " has been updated!"); if (q1 != "") { DbConnector.Execute($"UPDATE users SET {q1} WHERE user_id = {id}"); } if (q2 != "") { DbConnector.Execute($"UPDATE users SET {q2} WHERE user_id = {id}"); } if (q3 != "") { DbConnector.Execute($"UPDATE users SET {q3} WHERE user_id = {id}"); } Read(); }
static void Main(string[] args) { DbConnector.Query(Users)); }