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