private static void TestReadingDataUsingQueryProvider() { var role = new Role(); int conditionId = 0; Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}", "Id", "Login", "Password", "DepartmentId", "IsLocked"); using (var db = new UserManagementContext()) { var query = from user in db.Users where user.Id > conditionId select new { user.Id, user.Login, Pass = user.Password, user.DepartmentId, user.IsLocked, role.Name }; foreach (var user in query) { Console.WriteLine("{0}\t{1}\t{2}\t\t{3}\t\t{4}", user.Id, user.Login, user.Pass, user.DepartmentId, user.IsLocked); } } }
private static void TestReadingData() { Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}", "Id", "Login", "Password", "DepartmentId", "IsLocked"); using (var db = new UserManagementContext()) { var users = db.ExecuteStoreQuery <User>("SELECT * FROM USERS"); //var users = db.ExecuteStoreQuery<User>("SELECT LOGIN FROM USERS"); foreach (var user in users) { Console.WriteLine("{0}\t{1}\t{2}\t\t{3}\t\t{4}", user.Id, user.Login, user.Password, user.DepartmentId, user.IsLocked); } } }
private static void TestUserManagementContext() { using (var db = new UserManagementContext()) { // db.ExecuteStoreCommand(@"CREATE TABLE USERS // ( // ID int, // LOGIN nvarchar(100), // PASSWORD nvarchar(100), // DEPARTMENT_ID int // );"); //db.ExecuteStoreCommand(@"INSERT INTO USERS (ID,LOGIN,PASSWORD,DEPARTMENT_ID) VALUES ({0},{1},{2},{3});", 1, "user1", "user1psw", 123); //db.ExecuteStoreCommand(@"INSERT INTO USERS (ID,LOGIN,PASSWORD,DEPARTMENT_ID) VALUES ({0},{1},{2},{3});", 2, "user2", "user2psw", 234); } }