private void Initialize() { using (var db = new HelloWorldContext()) { var _modelRepository = new ModelDbRepository(db); var userTypes = (from ut in _modelRepository.Fetch <UserType>() select ut).ToList(); if (!userTypes.Any(u => u.UserTypeId == 1)) { Trace.TraceInformation("Inserting UserType"); var userTypeSystem = new UserType { UserTypeId = 1, UserTypeDescription = "System", CreatedOn = DateTime.Now, CreatedByUserName = "******" }; _modelRepository.Add(userTypeSystem); } if (!userTypes.Any(u => u.UserTypeId == 2)) { Trace.TraceInformation("Inserting UserType"); var userTypeBusiness = new UserType { UserTypeId = 2, UserTypeDescription = "Business", CreatedOn = DateTime.Now, CreatedByUserName = "******" }; _modelRepository.Add(userTypeBusiness); } _modelRepository.SaveChanges(); userTypes = (from ut in _modelRepository.Fetch <UserType>() select ut).ToList(); var users = (from u in _modelRepository.Fetch <User>() select u).ToList(); if (!users.Any(u => u.UserId == 1)) { Trace.TraceInformation("Inserting UserType"); var userJohn = new User { UserId = 1, FirstName = "John", LastName = "Doe", CreatedByUserName = "******", CreatedOn = DateTime.Now, UserTypeId = userTypes.FirstOrDefault().UserTypeId }; _modelRepository.Add(userJohn); } if (!users.Any(u => u.UserId == 2)) { Trace.TraceInformation("Inserting UserType"); var userJane = new User { UserId = 2, FirstName = "Jane", LastName = "Doe", CreatedByUserName = "******", CreatedOn = DateTime.Now, UserTypeId = userTypes.FirstOrDefault().UserTypeId }; _modelRepository.Add(userJane); } _modelRepository.SaveChanges(); } }