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