Fastest Way of Inserting in Entity Framework
Fastest Way of Inserting in Entity Framework
entity-framework
VB Net Class in C# [closed]
Need to make sure you’ve added the reference, as well as set the types you’re trying to access to public. Once this is done, you should make using references where appropriate, otherwise you’ll need to specify the entire namespace address each time you reference it. See Namespaces in Visual Basic and look over the code … Read more
summing values of a column based on id [closed]
First, I created a single table database to mimic the data structure: static void CreateAndSeedDatabase() { Context context = new Context(); TimeTracker entry1 = new TimeTracker() { UserId = 1, LoginTime = new DateTime(2000, 1, 1, 0, 0, 0), LogoutTime = new DateTime(2000, 1, 1, 1, 0, 0) }; TimeTracker entry2 = new TimeTracker() { … Read more
Linq: help me to make this work
You should group all person skills by person id, and then select only those groups, which contain both given category and sub category: unitOfWork.PersonSkillsRepository.GetAll() .GroupBy(p => p.PersonId) .Where(g => g.Any(p => p.IdCategory == ids.IdCategory) && g.Any(p => p.IdSubCategory == ids.IdSubCategory)) .Select(g => g.Key) For optimization, you can filter out skills which do not match any … Read more