C# (CSharp) RegisteredUserEFContext Exemples

Exemple #1

        public List <Domain.Models.RegisteredUser> Read()
        {
            using (var context = new RegisteredUserEFContext())
            {
                context.Database.Log = Console.WriteLine;

                var users = context.RegisteredUserEF.ToList();

                return(users);
            }
        }

Exemple #2

        public Domain.Models.RegisteredUser Read(int identifier)
        {
            using (var context = new RegisteredUserEFContext())
            {
                context.Database.Log = Console.WriteLine;

                var user = context.RegisteredUserEF.Find(identifier);

                return(user);
            }
        }

Exemple #3

        //private static void InsertToDoTask()
        //{
        //    var toDoTask_A = new ToDoTask
        //    {
        //        Description = "Task_A",
        //        CreatedOn = DateTime.Now,
        //        RequiredBy = DateTime.Now,
        //        CompletedOn = DateTime.Now
        //    };

        //    var toDoTask_B = new ToDoTask
        //    {
        //        Description = "Task_B",
        //        CreatedOn = DateTime.Now,
        //        RequiredBy = DateTime.Now,
        //        CompletedOn = DateTime.Now
        //    };

        //    using (var context = new TryItOutEFContext() )
        //    {
        //        context.Database.Log = Console.WriteLine;

        //        context.ToDoTasksEF.AddRange(new List<ToDoTask> { toDoTask_A, toDoTask_B });
        //        context.SaveChanges();
        //    }

        //}

        //private static void InsertRegisteredUser()
        //{
        //    var user_A = new RegisteredUser
        //    {
        //        Username = "******",
        //        Password = "******",
        //        Firstname = "David",
        //        Lastname = "Morton",
        //        IsActive = "True",
        //        LastLoggedIn = "",
        //        NumberOfAttemps = 0,
        //        Locked = false
        //    };

        //    var user_B = new RegisteredUser
        //    {
        //        Username = "******",
        //        Password = "******",
        //        Firstname = "Yogi",
        //        Lastname = "Mistry",
        //        IsActive = "True",
        //        LastLoggedIn = "",
        //        NumberOfAttemps = 0,
        //        Locked = false
        //    };

        //    using (var context = new TryItOutEFContext())
        //    {
        //        context.Database.Log = Console.WriteLine;

        //        context.RegisteredUserEF.AddRange(new List<RegisteredUser> { user_A, user_B });
        //        context.SaveChanges();
        //    }

        //}

        //private static void ReadToDoTask()
        //{

        //    using (var context = new ToDoTasksEFContext())
        //    {
        //        context.Database.Log = Console.WriteLine;

        //        var tasks = context.ToDoTasksEF.ToList();

        //        var task = context.ToDoTasksEF.Where(x => x.Identifier == 5);
        //    }

        //    var keyval = 1;
        //    using (var context = new TryItOutEFContext())
        //    {
        //        context.Database.Log = Console.WriteLine;

        //        var task = context.ToDoTasksEF.Find(keyval);
        //    }

        //}

        //private static void ReadandUpdateToDoTask() {

        //    using (var context = new ToDoTasksEFContext())
        //    {
        //        context.Database.Log = Console.WriteLine;

        //        ToDoTask task = context.ToDoTasksEF.FirstOrDefault();

        //        task.CompletedOn = DateTime.Now;

        //        context.SaveChanges();
        //    }

        //}


        private static void InsertRegisteredUser()
        {
            var user_A = new RegisteredUser
            {
                Username        = "******",
                Password        = "******",
                Firstname       = "David",
                Lastname        = "Morton",
                IsActive        = "True",
                LastLoggedIn    = "",
                NumberOfAttemps = 0,
                Locked          = false
            };

            var user_B = new RegisteredUser
            {
                Username        = "******",
                Password        = "******",
                Firstname       = "Yogi",
                Lastname        = "Mistry",
                IsActive        = "True",
                LastLoggedIn    = "",
                NumberOfAttemps = 0,
                Locked          = false
            };

            using (var context = new RegisteredUserEFContext())
            {
                context.Database.Log = Console.WriteLine;

                context.RegisteredUserEF.AddRange(new List <RegisteredUser> {
                    user_A, user_B
                });
                context.SaveChanges();
            }
        }