public void QueryStruct() { IConnection connection = Program.GetOpenConnection(); if (!connection.ExistTable <UserStruct>()) { connection.CreateTable <UserStruct>(); } try { UserStruct user1 = new UserStruct { id = 1, username = "******", password = "******" }; UserStruct user2 = new UserStruct { id = 2, username = "******", password = "******" }; connection.Insert(user1); connection.Insert(user2); Console.WriteLine(user1); Console.WriteLine(user2); user1 = connection.Get <UserStruct>("un2"); Console.WriteLine("Get user struct 2: " + user1); } finally { connection.DropTable <UserStruct>(); connection.Close(); } }
public void QueryStruct() { IConnection connection = Program.GetOpenConnection(); if (!connection.ExistTable<UserStruct>()) connection.CreateTable<UserStruct>(); try { UserStruct user1 = new UserStruct { id = 1, username = "******", password = "******" }; UserStruct user2 = new UserStruct { id = 2, username = "******", password = "******" }; connection.Insert(user1); connection.Insert(user2); Console.WriteLine(user1); Console.WriteLine(user2); user1 = connection.Get<UserStruct>("un2"); Console.WriteLine("Get user struct 2: " + user1); } finally { connection.DropTable<UserStruct>(); connection.Close(); } }