static void Main(string[] args) { try { //AddUsers(); //LazyLoadUserGroups(); //GetActiveUsersWithSp(); using (var ctx = new EFTestDbEntities()) { ctx.pGetUsers(true); } } catch (DbEntityValidationException vex) { //TODO log and fix invalid stuff } catch (Exception e) { Console.WriteLine(e); throw; } Console.ReadKey(); }
private static void GetActiveUsersWithSp() { using (var dbCtx = new EFTestDbEntities()) { dbCtx.Database.CommandTimeout = 10; dbCtx.Configuration.LazyLoadingEnabled = true; dbCtx.Database.Log = Console.WriteLine; var activeUsers = dbCtx.pGetUsers(true); foreach (var activeUser in activeUsers) { Console.WriteLine(activeUser.Name); } } }