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.

Filter by
Sorted by
Tagged with
2
votes
1answer
305 views

Custom data validation approach for store items and prices

I came up with a validation design for my project and wanted to hear if there's anything I could improve. Here's how it works. I have the models (code first) ...
-1
votes
1answer
321 views

EF Code First BaseContext-class [closed]

I've seen a tutorial where a dbcontext base class is created like so: ...
4
votes
1answer
1k views

Utilizing Areas to handle subdomains with shared state/resources

I am currently working on a side-project and have the basic foundation and architecture I want in place for the site. I wanted to get your opinion and thoughts on my current practices and methods ...
4
votes
1answer
103 views

Joining tables with EF

Here is my database: Here is my viewModel: ...
8
votes
2answers
103 views

Code First approach, feeding the table

I have a database (PostgreSQL) from which I want to migrate some data to a MS SQL Server database. I decided to use a code first approach. The question is related to the proper way of feeding my new ...
8
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: ...
2
votes
1answer
136 views

Entity Framework Code First Softball Stats Database Schema

I am creating a website for my buddies and I to track all of our offensive softball stats. I am getting tired of maintaining a huge excel spreadsheet and emailing it out every week, so a website is ...
5
votes
2answers
191 views

Keeping data processing out of controllers

I would like to start by mentioning that I am LAMP stack guy who happens to be making my first ever .NET C# web app and I'm seeking general advises for best practices and to see how more experienced ...
1
vote
2answers
183 views

A polling method and nested loop

There are 12 gates. Using our face recognition system, we check every person who tries to enter each gates. My MVC web application is to show the result data to the gate-keeper. And this is the ...
2
votes
1answer
480 views

DbGeography search query

I have a situation in which I need to get the closest road to a DbGeography point. This takes 5 - 8 seconds to run in some cases. I have a ...
4
votes
2answers
26k views

Linq-to-Sql Contains an int? inside a list of int

Curious if there is a better way to write a repository method that receives argument List<int> and checks if the database ...
2
votes
2answers
110 views

Sales Tax problem (new version)

I was told that this version is too simple, that need something more complex. I added Entity Framework. Here my code: ...
3
votes
2answers
401 views

View Model Constructor Arguments

I have created a ViewModel for a Product Edit page because it has specific related entities I need to load - the class currently looks like this: ...
3
votes
1answer
3k views

Entity Framework 7 In Memory Database - Unit Testing using xUnit

I'm using EF7 with In-Memory database and xUnit for repository testing. I'd like to know if it's a good practice initializing the database in this manner for reuse it in every test method, ...
0
votes
2answers
75 views

Saving or updating to databse

What would be the best way to refactor following method? ...
4
votes
0answers
281 views

Unit of work with Repository pattern

I am trying to work on a WPF application and decided to go for Unit of Work and Repository pattern, along with MVVM. I am using Entity Framework as my ORM. Could ...
3
votes
1answer
138 views

Extracting SoftDelete from DbContext

I have a DbContext with a SoftDelete implementation inside it. To make it more clear and maintainable, I wanted to extract it to ...
3
votes
3answers
6k views

Master detail INSERT in Entity Framework 6 Database First MVC 5

I have a DB with a master table called "facturas" and another detail table "facturas_detalle." I would like to insert to them, so this is a "Database-First". I need some guidance or advise of best ...
2
votes
0answers
914 views

Update Virtual Property in a Code First Model using Independent Association in Entity Framework 6

I have a Model that looks like this: ...
4
votes
1answer
342 views

Resolve entity behaviour based on enumeration type

The core of this question is removing a Static Class smell from my Web-Api/MVC solution. It presently works but feels kind of dirty. Present Solution Standard solution with 6 projects: MVC Api Api....
-4
votes
1answer
125 views

Which way is better (matching Onion Architecture in MVC pattern) for using Provider?

In onion arch. we have multi layer structre: UI (User interface). BL (Business Logic / Services). RE (Repositories). UI uses BL to get data from RE with some conditions, my question is which is ...
3
votes
1answer
6k views

Run stored procedure from repository using EF

I need to dynamically call a stored procedures from my repository, and here is a my implementation: ...
8
votes
1answer
17k views

EF Generic Repository + Unit of Work pattern with support for Async

I'm working on a generic repository using EF 6 code first and trying to following the Unit of Work pattern. Unity is being used to inject my repositories, and I'm trying to get everything supporting ...
3
votes
1answer
408 views

N-tiered web app to save a role

My project manager is saying that there are many bad things in my code, but they are not helping me to correct it. Can you please specify the bad things they mean? I have 7 projects in my solution ...
2
votes
1answer
159 views

Publishing and removing database tables

I have a switch statement that works just fine, however, it has a lot of duplicate logic within it. I have an enum that my controllers use to say which is making the publish request, so ...
4
votes
1answer
9k views

Listing users in Azure Active Directory

The code below is the Index Action from a User Controllers. Basically this code returns a list of users from Azure Active Directory using Azure Authentication Library (ADAL). However I need to show ...
2
votes
1answer
192 views

Cross-Database Query Without Casting to List

I am trying to do a cross-database query without having to enumerate the variable t. ...
1
vote
1answer
107 views

Cross-cutting delete flag in a repository

I want to have a cross-cutting delete flag in my repository. I have the following repository pattern at the moment: ...
0
votes
2answers
1k views

Optimizing LINQ routines

I run a build system. Datawise the simplified description would be that I have Configurations and each config has 0..n Builds. Now builds produce artifacts and some of these are stored on server. ...
2
votes
2answers
619 views

Delayed Include rules for EntityTypeConfiguration using LINQ expressions

The aim of this class is to set rules for including navigational properties on Configuration level and then apply where needed in the code. I've decided to store expressions in the list for different ...
5
votes
4answers
2k views

Generic Repository For Web Apps

I was developing a web app using Entity Framework 6 and MVC 5. For the data access layer, I eased the job and wrote a generic repository as following: ...
2
votes
1answer
679 views

Thread-safe database updates

I have the following method that will return VariantID for given VariantName ("Name" in db). To avoid calling my db few thousand times I have dumped all records (~30) to the simple dictionary. I'm ...
3
votes
2answers
98 views

Linq to entities query for donor registrations [closed]

I'm using Linq-to-Entities for querying, and MVC.NET and C# for coding. I'm trying to generate monthly donor registry report which needs donor count, donors who signed through web,donors who ...
4
votes
1answer
5k views

Returning IQueryable<T> from my repository in Repository pattern design pattern

I am developing an application based on Repository design pattern. What should be the return type from the Repository? This is my UserRepository class: ...
2
votes
1answer
14k views

Table join using the repository pattern

I am new to repository pattern. If I want to join two tables, where should I implement the logic? I have implemented it as shown below. Is there any better way to achieve the same? This is my ...
2
votes
0answers
88 views

DataDictionary Application - Controller

This is related to DataDictionary Application - Model I haven't done much on the controllers yet, as it's the first time I've written Controller-type classes and wanted some quick feedback on really ...
2
votes
1answer
523 views

DataDictionary Application - Model

Following on from my previous question, I think my Entity Framework model code is now complete. First I'll provide a quick overview of the program - everything above the next horizontal rule can be ...
2
votes
1answer
3k views

MVC Repository Insert Using async

This is practically my first time using async in my code. I read about dos-and-donts but I wanted to get some feedback on what I've written. I'm using a repository ...
1
vote
1answer
10k views

Converting table data into nested JSON

I'm new to C# (coming from a JavaScript background) and it seems like this code could be greatly improved. This SQL query: ...
2
votes
1answer
88 views

Organising structurally very similar classes

A little background - these are classes I've written on top of an Entity Framework model that represents tables on Sql Server with the following names: ...
0
votes
1answer
154 views

Awkward Generic Repository Call [closed]

I am implementing a generic repository pattern. I have done this quite a few times now but every time I do it there is something bugging me. If I have a database design like below. (All the tables ...
4
votes
2answers
897 views

Two functions to impose order on queries

I am writing a c# program to build generic sort algorithm on a request to a collection of data. The data needs to be sorted based on the supplied columns.I am using Entity framework and Expression ...
6
votes
2answers
5k views

EF lookups and enums

I have a lookup table "RequestTypes" that has the following data: ...
2
votes
0answers
12k views

Retrieving Primary Key from Entity Framework entity

Entity Framework (version 6) generates classes based on your tables that look like this (where each property represents a field in the table): ...
1
vote
0answers
69 views

Query against history table

I have this linq query that queries a table that retains any change history done to any of the tables is constructed like this: ...
2
votes
1answer
478 views

Logic for changing entity navigational properties States

The question might seem a little bit long, but I will be very glad if you have read it till the end and told me your opinions. Let's say I have such entity: ...
1
vote
2answers
252 views

Code separation in MVC

Firstly I am not a professional programmer and I am just learning C#, MVC and Web Development. Much of what I describe here is self taught and comes from lots of googling and posts on Stack Overflow. ...
8
votes
2answers
2k views

Allowing query handlers to use other query handlers

I recently started looking into CQRS when using Entity Framework and the impact it has had on my systems has been overwhelming. I implemented the following patterns described in these blog posts: ...
2
votes
1answer
89 views

Query the context or resulting list

I was just getting some products using entity framework and was wondering which would be better to do when getting the results, or if there is no difference. Option 1 - Query the context directly <...
1
vote
3answers
2k views

Dealing with DB Through EF within Winforms

I have the following code which uses EntityFramework to reach out to a DB and retrieve data to populate into a Winform application gridview. I am still quite new ...