Questions tagged [entity-framework]
The ADO.NET Entity Framework is a set of ORM (Object-Relational-Mapping) tools for the .NET Framework, since version 3.5 SP1.
380
questions
-4
votes
0answers
25 views
C# LINQ CODE REFACTORING [on hold]
I'm using entity framework to get data from a db, I'm also using linq to group the data and some stuffs linke that, and I've just wrote a method which is grouping data by it's status:
...
4
votes
1answer
3k views
Generic repository and generic service
I use the Repository/Service design pattern in my projects. I have doubts whether it is worth using common services
BaseEntity:
...
1
vote
1answer
696 views
5
votes
3answers
148 views
Collect reporting data for each possible combination of filter properties
Basically I'm looking for a way to improve my code, and avoid making a lot of if statements and parameter combination manually, 'cause I need to return a query result depending in the parameters that ...
1
vote
0answers
21 views
Console app to get XML from API and save to database
I am making a small console app to get XML from an API and then save the data to a database. While this project was not created via test-driven-development, I have tried to make it such that tests can ...
3
votes
1answer
81 views
Initializing entity framework context in constructor
We use the architecture shown in the code below to initialize the DB context for our MVC 5 project using entity framework 6
We have the following questions related to it:
Is it safe to initialize ...
3
votes
1answer
103 views
Small application for manipulating users and their activities
I made a small application using C#, SQL Database, entity framework , and windows forms to manipulate users (...
0
votes
0answers
39 views
Entity Framework C# updating an entity list generic solution
I have an entity which has a list of other entities in it.
for example:
class Library
{
public virtual List<Book> Books{get;set;}
}
And I would like to ...
6
votes
1answer
486 views
IQueryable Extensions working on expression for collection property
Followup to Repository searching code duplication
My goal currently is to make the current implementation of my repository's IQueryable filtering less duplicative. First, I looked into passing ...
2
votes
2answers
39 views
LINQ queries to generate a report on accrued work time on projects
The following code fetches data from a MySql database to generate a simple report on accrued work time on projects.
I've been away from Entity Framework for a while and looking at this code you can ...
1
vote
1answer
43 views
Authorization using Entity Framework in ASP.NET MVC
1. Backstory
I recently starting programming and I found out that Entity Framework works perfect for my small-sized applications due its simplicity.
I've made my custom authorize attribute for MVC ...
8
votes
2answers
12k views
DbSet<T> IncludeAll method
The Problem
As an ASP.NET MVC4 developper, I'm using Entity Framework a lot. Considering performance I often use lazy loading for my models.
...
2
votes
1answer
222 views
Generic UnitOfWork
I am trying to create a Repository & UnitOfWork for Data Access Layer. In my current implementation I have to modify my UnitOfWork everytime I create a new repository. I would like to avoid that ...
11
votes
1answer
2k views
Efficient way to deal with maintaining Many:Many relationships in EF Code-First
I've got this all working, but it seems to be quite long-winded, and I thought I'd post here and see if I'm doing it wrong...
I have a M:M relationship between an Installer and a MasterInstance. The ...
3
votes
2answers
733 views
Optimize OrderBy Generic Method
Here is my OrderBy method which includes concatenated column names.
Can this be achieved more efficiently?
...
3
votes
1answer
669 views
Dynamic AuthorizeAttribute with database
I want to create a AuthorizeAttribute that gets the current ActionMethod RouteData and ...
8
votes
1answer
2k views
GroupBy(params string[] fields)
Linq to Object GroupBy extension method allows grouping by projection:
...
-1
votes
1answer
86 views
Handling Entity Framework in connected mode within Windows Forms [closed]
I know the difference between the Entity Framework connected mode vs disconnected mode. In connected mode we do all the stuff inside one single DbContext instance. ...
1
vote
2answers
232 views
Using IQueryable.GroupBy to count related database entities
Given a DbSet<Client> from an Entity Framework 6 DbContext, I need to count the number of related ...
1
vote
1answer
56 views
Repository to update flights
I have the Repository below, but I have noticed that there is a recurrent pattern try / catch which does not seem to be that ...
0
votes
0answers
49 views
Loading data via Excel to SQL
I am loading data from a excel file to sql, I added comments to the code to further clarify what each lines purpose is.
...
1
vote
0answers
1k views
Transaction integrity in asp.net core with entity framework and generic repository
I am not very experienced in Entity Framework, I previously used ADO.Net and Dapper for data persistence. For now, I only read Microsoft docs and watched a few video tutorials. I tried to stick to ...
5
votes
2answers
37k views
Class to DataTable or Datatable to class mapper
My code goes from a class to DataTable, and back again. It populates the class's public properties, or creates DataColumns whose ...
2
votes
0answers
1k views
Using Entity Framework to Call an Oracle Stored Procedure with Multiple Cursors
I wrote the following code to use Entity Framework 6 and Managed Oracle Providers to call an Oracle stored procedure that returns multiple cursors.
Would like some input about the code I used to ...
1
vote
1answer
16k views
Entity Framework - Add or Update Parent Entity with Children
This code saves an DomainEntityRecord (parent) and DomainEntityDetailRecords (child), and it works. It feels odd that I get the ...
2
votes
1answer
862 views
Navigation properties with sql/dapper
I want to have the same experiance with slq/dapper for my navigation properties just like in Entity Framework.
But I'm not sure which sql query i should use.
As you see, every single Resource entity ...
5
votes
2answers
9k views
Proper way to work with stored procedures in Entity Framework Core
I need to work with stored procedures, with the help of Entity Framework Core. This is my function:
...
8
votes
1answer
12k views
MVC 5 & EF 6 - Repository & Unit of Work Pattern
I have been looking through Code Review on the subject of Unit of Work and Repository patterns and realised that my implementation appears to provide very similar functionality but in reverse class ...
3
votes
1answer
54 views
Registering an event participant, using Entity Framework and several associated models
I have a method that is responsible for receiving an object and perform the information saved with Entity Framwork, using the Repository pattern. The issue is that this object is, basically, a DTO. ...
9
votes
4answers
20k views
Threadsafe DBContext in singleton
I found out the hardway that access to DbContext in .NET is not threadsafe. I have a singleton for logging things using a dbcontext. The original version uses something like
...
5
votes
2answers
3k views
Repository pattern along with EF and Unit of work
I'm new to this Repository pattern and have seen lot of repository pattern + UoW implementations all over the internet and I'm not able to reach to a conclusion as to which of them is correct . After ...
2
votes
1answer
4k views
Injecting a DbContext with an async constructor dependency
The goal is to construct a DbContext with a connection that uses an access token. The access token is acquired with ADAL (Active Directory Authentication Library).
...
2
votes
0answers
111 views
How to optimize code to only pull separate table rows that are necessary
I have a Company Class, and separate normalized Address Class. I did this because the Address table will hold more than just Company Addresses, so I don't want "CompanyAddress", "EmployeeAddress", "...
2
votes
1answer
3k views
Adding or updating Company entity
Here I am trying to post a company view-model and update and insert according. But I feel I am writing it in wrong way or maybe there's a better approach.
Here's my code
...
0
votes
1answer
163 views
Filtering DbContext data dynamically by user input in WPF applications
I need to filter database data based on filters available to the end user in the form of search term text box, select boxes etc.
I have put together this code and need feedback if this is a good way ...
2
votes
0answers
39 views
Correct Way to Retrieve Header Records With Filtered Detail Records [closed]
I wrote this in LinqPad. It works. The whole point was to retrieve header records, and only include some detail records. I'm looking for possible improvements to this, specifically around the ...
-3
votes
1answer
107 views
Implement Entity framework insert with better performance [closed]
I have very slow performances on EF.
I have many foreach, mappings.
Do you have suggestion?
I would like to make improvement without complicated refactoring and I would like to use EF.
...
3
votes
2answers
1k views
Entity Framework Lazy loading performance comparison
The following code takes about 20 seconds to run with about 200,000 records in the TaskLogs table:
...
4
votes
2answers
12k views
Joining to in memory List
I have an in memory list that I am joining to results from a query using entity framework. My list will most likely never be greater than 2500 records. The results from the database can fluctuate, ...
-1
votes
2answers
78 views
Improving predominance for updating 40000 records using entity framework [closed]
I have Two tables Circuit and Tag,
Circuit
------------------
Id Name Path
Tag
-----------
Id Name Circuit_Id
Now I have to loop through all the tags and ...
1
vote
1answer
697 views
ASP.NET Identity 2.0 UserManager alongside with UnitOfWork and Service-Locator anti-pattern
I was wondering whether it is a good aproach to have Identity 2.0 UserManager next to UnitOfWork pattern? I am using ...
6
votes
2answers
11k views
Get total count of object's elements and all children objects` elements
I have a table, Taxonomy, with data that looks something like the following:
...
1
vote
1answer
72 views
Controller with TemplateService
I am working on my template web api project.
I just wanna hear any suggestion how to improve this code. I heard that repository pattern is anti pattern so I want to make code without it. Any opinion ...
2
votes
1answer
2k views
Service Layer, using Entity Framework 6.2
I would like you to review a part of my warehouse application, a Service Layer to be exact. The architecture of the program is:
DB --> .Data (EF's DbContext/...
2
votes
0answers
944 views
Entity Framework with two databases (with UoW, Repository and Service Layer)
I have two databases: one for a warehouse, second for the office (The db design is out of the scope of this question). There are MANY cross-database funtions. One of those functions is ...
0
votes
1answer
1k views
How to optimize a nested foreach loop which is creating same data object (with different values)
I have following code which gets MastrSegments from repository(entity framework). It's working but I think I am violating DRY (though not sure).
MastrSegments conatins collection of SegReqs and ...
3
votes
3answers
350 views
Claiming coupons [closed]
I am currently creating a system that allows a user to claim a coupon, after the coupon is claimed the receive currency on their account.
I recently ran into an issue in which if 2 requests with the ...
0
votes
1answer
57 views
Data validation for to check required fields are mapped
Can I break the below foreach and IF statements into LINQ expression. Also, performance wise which will be better. Please suggest.
...
2
votes
0answers
131 views
EF mapping complex type to JSON in DB
I am trying to map a complex type to Json and store the info as Json in the DB using EF6 Code First.
Here's what I have for now:
The complex type
...
1
vote
0answers
43 views
Querying a database to find notifications to comments
I have a solution what I think is not the best, and I want to make this not so expensive.
I'm using MVC 5 + SignalR (hubs) + EF + UnitOfWork + Generic Repos.
I have a table ...
