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.
399
questions
2
votes
1answer
92 views
Parsing large text files into database
I'm a new self taught "programmer" that has been given the task at my job to parse through generated .txt test records and insert the data into a database. Usually when given a task like ...
4
votes
0answers
108 views
Repository pattern method implementation with entity framework and C#
I have two entities in my database: Employee and Shift. I want to implement a C# repository pattern method, that given two ...
1
vote
0answers
24 views
Preventing the user from entering the same categories [closed]
I'm new to MVC and EF so this may be a really simple question, but what is the best way to prevent the user from trying to enter duplicate records?
I have a table called Category with two columns Id ...
1
vote
0answers
44 views
Addition/removal of entities in EF6 many-to-many architecture
Is there a way to do this many-to-many update with less code? It feels awfully bulky to me.
I started out using AutoMapper to avoid the explicit value assignments, but then the mapped ...
1
vote
0answers
19 views
Adding multiple child entities to a parent entity when creating the parent entity
I have a form on a page to add a Post (parent), before submitting the form, a user should be able to add 1 or more Sections (children) to the Post.
The form:
...
2
votes
1answer
25 views
View model using different datetime component
Any advice on how to make this code; cleaner, more effective, just overall better!
Program setup object that is coming from the database EF. It then maps the object to a view model and converts ...
2
votes
1answer
171 views
Entity Framework Core DbFunction for square root
I'm porting my site over from .NET Framework / MVC 5 / EF6 to .NET Core 3.1 MVC / EF Core. MSSQL Server for the database.
EF6 has SqlFunctions of which one method ...
4
votes
2answers
78 views
pagination in entity framework and refactoring
I have an api end point which returns the paginated result, the corresponding code for that is as below:
...
1
vote
1answer
31 views
Many to Many Relationship using EF Core
I've implemented Many-To-Many relationship and wonder if this is the optimal way for it. Since I do not have extensive EF Core experience I would love if someone with more experience could check it ...
1
vote
0answers
61 views
Entity Framework optimization when using transactions
I want to save NUnit local tests in a mysql database hosted in Amazon RDS, and
I'm wrapping up everything in a transaction like so :
...
2
votes
0answers
43 views
Sharing model for different ORM's
I am building a MySQL to Realmdb converter app.
I use Entity Framework to deal with MySQL, so below is the code of one of my model classes. I don't want to have multiple classes representing the same ...
2
votes
0answers
20 views
Web API wrapper design and sharing EF database context
I'm trying to keep my sanity while working with a legacy winforms application that uses an web api, both maintained by my team.
In the past we have multiple cases of methods using wrong api endpoints,...
11
votes
3answers
14k 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.
...
9
votes
2answers
5k views
Query Builder pattern with use of FluentApi
Recently, I've come up with an idea of building a custom query builder combine with FluentApi.
Expected usage:
...
1
vote
0answers
39 views
Concurrent requests are not permitted in specific time period
In my web API, the client wants me to implement logic in order to control/block concurrent requests in a specific time period. I added RequestInterval which is 10 seconds in the appsettings of web ...
9
votes
3answers
473 views
Creating a round robin MySQL connection manager
Background
I am working on an e-commerce website, my web server is written in ASP.NET MVC (C#, EF6) and I am using 3 instances of MySQL DB. These DBs are in a cluster (Galera Cluster) and they are ...
4
votes
1answer
471 views
C# Windows Forms App: Adding An Element To The BindingSource And Save These Changes To The DB [closed]
I have build a C# Windows Forms app that used Entity Framework(DB first model). For the data I am using a .mdf database file.
The data view of dbo.students:
GUI:
The Form1 class:
...
1
vote
1answer
61 views
ASP.NET EF seed one to many relation
I am creating a simple model relation in ASP.Net core. My model relations are like this:
A user can have many posts
A post can have many comments
A user can have many comments
Now I am trying to ...
0
votes
2answers
83 views
Multiple conditions for same table in EF
I am getting products using given parameters (name of real entity and columns changed for illustration purposes),
...
1
vote
1answer
77 views
Exposing includes to client over webservice for database queries
I am using a CQRS type patter for querying data in my application. I am currently using entity framework to connect to the database.
...
1
vote
1answer
80 views
Entity Framework invoice queries
I have these queries written in Entity Framework where I try to get:
Name of the customer
Most Recent Invoice Ref
Most Recent Invoice Amount (£)
Number of outstanding invoices (#)
Total of all ...
4
votes
1answer
306 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 ...
1
vote
1answer
46 views
Using nullable properties in a base class for record selection in Table per Hierarchy
I want to be able to list every Transaction associated with a Client in date order.
...
13
votes
4answers
21k views
Storing Enum values as Strings in DB
I have a Data First Migration and have been struggling a little with storing an enum value as a string.
(Im aware that enums should be stored as ints but, personally I have never liked this, yes ...
1
vote
1answer
34 views
Calculate sum of an attribute across multiple repositories
I have multiple repositories that contain userId, paidDate and amount attributes like ...
1
vote
1answer
94 views
ASP.NET MVC 5, EF 6 filter performance
I'm creating a filter with Linq in an ASP.NET MVC application. I was hoping I could get some tips on performance enhancements, aside from any possible performance enhancements.
I have a few questions:...
5
votes
1answer
4k 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
958 views
5
votes
3answers
149 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
26 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
118 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
91 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
724 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
43 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
90 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 ...
2
votes
1answer
466 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
911 views
Optimize OrderBy Generic Method
Here is my OrderBy method which includes concatenated column names.
Can this be achieved more efficiently?
...
3
votes
1answer
1k views
Dynamic AuthorizeAttribute with database
I want to create a AuthorizeAttribute that gets the current ActionMethod RouteData and ...
8
votes
1answer
3k views
GroupBy(params string[] fields)
Linq to Object GroupBy extension method allows grouping by projection:
...
-1
votes
1answer
100 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
2k 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 ...
2
votes
1answer
67 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 ...
1
vote
0answers
2k 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
41k 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
2k 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
20k 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
2k 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
10k 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 ...