An ORM built by Microsoft and is available as part of .Net framework 3.5 and later.
0
votes
0answers
84 views
What's the best way to expose a Model object in a ViewModel?
In a WPF MVVM application, I exposed my model object into my viewModel by creating an instance of Model class (which cause dependency) into ViewModel. Instead of creating separate VM properties, I ...
3
votes
1answer
44 views
Why DbContext object shouldn't be referred in Service Layer?
I've been looking for some implementations of Service Layer and Controller interaction in blogs and in some open source projects. All of them seem to refer DbContext object in repository classes but ...
1
vote
2answers
207 views
Correct way to inject dependencies in Business logic service?
Currently the structure of my application is as below
Web App --> WCF Service (just a facade) --> Business Logic Services --> Repository -> Entity Framework Datacontext
Now each of my Business logic ...
-5
votes
0answers
56 views
Performance Evaluation: Entity framework is faster then legacy ADO.NET? [closed]
Is using Entity framework any good for the software being developed in terms of speed?
0
votes
1answer
127 views
In what situation do Entity Framework enums become useful?
I am working on a project where there will be plenty of static options being stored in the database. I looked at using Enums for this, but do not see how they could be useful.
They do not create any ...
1
vote
1answer
117 views
entity framework 6 agnostic enough different sql server and OS platforms?
It's my first time using sql server, I usually go with MySQL, so I'm unsure how to do this.
The project I'm assigned will be deployed to multiple platforms particularly PC's with different SQL server ...
0
votes
1answer
101 views
Claim based authorization for application framework? [closed]
I am developing a framework that makes common data management tasks easier for a couple of future applications built on top of it, including document management, data versioning, retention, locking ...
1
vote
0answers
140 views
Entity Framework - Loading Related Entities Explicitly
I have been using Entity Framework for a few years. I have flip-flopped between calling out to repositories in my business logic or using lazy loading to retrieve data as I work my way through the ...
-3
votes
1answer
82 views
Entity/Collection change tracking by DbContext [closed]
Can someone explain me how entity changes and entity collection changes are tracked by DbContext in Entity Framework 6 where entities are POCO type (not derived from EntityObject)? I experimented with ...
2
votes
5answers
274 views
Create Database To Fit Data vs Make Data Fit The Database
I'm newish to programming and would like to know what people have found to be the most supportable option or rather what people find more understandable. I'm the only one writing code at my firm, but ...
2
votes
4answers
207 views
At what point does data access\manipulation logic becomes business logic?
Consider a service which updates PersonDetail tables in database. I am Using EF which maps the table to this Entity. When a record is updated, it is not actually updated but a new record is created ...
0
votes
2answers
450 views
How to connect mvc application using entityframework or ado.net?
I am an ASP.NET developer. I want to learn ASP.NET MVC. In fact I am learning it. But Now I am confused at a point. How can I connect my database to my application. Using entity framework or linq or ...
0
votes
0answers
54 views
How to handle field level Acces Security when using Entity Framework
Scenario: a large existing system (~300 tables, 500 stored procs, 200 views and a code base of several 100k lines) with most security level stuff in stored procedures needs to be refactored (for ...
2
votes
1answer
191 views
Would this be a correct way to use the Repository pattern in ASP .NET MVC application implementing Entity Framework?
This ASP .NET MVC application implements Entity Framework.
I've declared the repositories in the DbContext like this:
public class CompanyDbContext : DbContext
{
// constructor goes here
...
3
votes
3answers
946 views
How to get around the Circular Reference issue with JSON and Entity
I have been experimenting with creating a website that leverages MVC with JSON for my presentation layer and Entity framework for data model/database. My Issue comes into play with serializing my ...
1
vote
1answer
191 views
How to use Git with ASP MVC Code-First Entity Framework [closed]
TLDR: What is an effective way to use Git to handle ASP MVC code-first EF? Which files need to be included for NuGet? Which files should be left out?
We have an ASP MVC code-first Entity Framework ...
1
vote
3answers
161 views
Should entities be accessible from all layers of an application? [closed]
I am googling this issue now for weeks, but cannot find a good discussion.
It boils down to this:
As POCO entities used in a dbContext are in fact a definition of the database, shouldn't they be ...
0
votes
0answers
41 views
IUserType like feature inEntity Framework
I'm working on a new project, we want to build a new, modern, application working with our legacy data sources, and especially, legacy databases. We want to use an ORM and we want advanced features so ...
2
votes
1answer
459 views
How to split up ASP MVC Project using Code-First Entity Framework
For an academic exercise, we have been tasked with creating a small website. We have already gathered the requirements and fleshed out the business domain to see the classes we are supposed to ...
1
vote
1answer
492 views
What are the disconnected scenarios in Entity Framework?
I'm not sure I understand what all fall under the disconnected context scenarios in EF (See this and this). This link says use Web API or WCF services to avoid the complexities of disconnected tier EF ...
0
votes
2answers
208 views
How do I read the Entity Framework Model and validate it against a given connection?
I have a Entity Framework Database First Model.
I want to write a MSTest/nUnit test to verify that all the stored procs, tables and views that are defined in my edmx model are still valid on the ...
1
vote
1answer
192 views
How do I architect zip code & distance calculation functionality?
I am building an app using MVC 4/Razor and EF 4/ .NET 4 in which it is possible to search items by zip code and thus retrieving items only a certain distance from your current zip code. I have a class ...
0
votes
1answer
98 views
Inheritance with Entity Framework Code First
I'm starting work on a new personal project and I'm looking to get advice in regards to setting up my classes.
My base class is a User. The User class will have the following general properties
...
1
vote
2answers
104 views
Should db be mapped directly to the UI or should there be multiple layers of enties/models with mappings to/from each?
I would like to know arguments for/against this concept.
Technologies in use from the bottom up:
MSSQL 2012 DB (exclusively accessed via sprocs)
Entity Framework
WCF Web Service
ASP.NET Webforms
...
0
votes
2answers
391 views
What is right choice of Data Access Layer for large application
I am using Singleton pattern for my application, I have used ADO.NET Entity framework as my Data Access Layer, after login to my application, it's taking 3 to 5 minutes to load the dashboard.
Is ...
1
vote
1answer
2k views
DbFirst vs Code First? what should I use if I rely on Stored procedures
This question is asked many times, and I always prefer code-first as I like to keep the logic in code.
But now I have a challenge to load screen under 5 seconds and very little time to do things.
I ...
9
votes
3answers
1k views
Entity Framework Entities - Some Data From Web Service - Best Architecture?
We are currently using Entity Framework as an ORM across a few web applications, and until now, it has suited us well as all our data is stored in a single database. We are using the repository ...
0
votes
1answer
119 views
Are there any concerns with using a static read-only unit of work so that it behaves like a cache?
Related question: How do I cache data that rarely changes?
I'm making an ASP.NET MVC4 application.
On every request the security details about the user will need to be checked with the ...
2
votes
3answers
1k views
How do I cache data that rarely changes?
In my ASP.NET application there is some data that doesn't change often and so there is no point in querying the database to re-check it every time.
In my current situation I am checking user ...
2
votes
1answer
443 views
Entity framework and Eager loading and enterprise application with DDD aproach
We are trying to create an ASP.NET MVC 4 application using entity framework with domain driven development style pattern approach. As you can see in our part of domain layer, we have a complex design. ...
0
votes
0answers
137 views
Entity framework separating entities for product and customer specific implementation
I am designing an application with intention into making it a product line. I would like to extend the functionality across all layers and first struggle is with domain models.
For example, core ...
1
vote
2answers
1k views
Design pattern for an ASP.NET project using Entity Framework
I'm building a website in ASP.NET (Web Forms) on top of an engine with business rules (which basically resides in a separate DLL), connected to a database mapped with Entity Framework (in a 3rd, ...
0
votes
1answer
3k views
Entity Framework 5, separating business logic from model - Repository?
I am working on my first public-facing web application and I’m using MVC 4 for the presentation layer and EF 5 for the DAL. The database structure is locked, and there are moderate differences ...
4
votes
3answers
289 views
Architecting multi-model multi-DB ASP.NET MVC solution
I have an ASP.NET MVC 4 solution that I'm putting together, leveraging IoC and the repository pattern using Entity Framework 5. I have a new requirement to be able to pull data from a second database ...
1
vote
1answer
379 views
Is there a situation where DataSet is better than using EF? [closed]
We are starting to develop web application for our client. Though I am not convinced, we are going to use DataSet as our data access. One of the reason is that most of the team members have experience ...
7
votes
3answers
5k views
What the best way to wire up Entity Framework database context (model) to ViewModel in MVVM WPF?
As in the question above: What the best way to wire up Entity Framework database model (context) to viewModel in MVVM (WPF)?
I am learning MVVM pattern in WPF, alot of examples shows how to implement ...
1
vote
2answers
410 views
Entity Framework and distributed Systems
I need some help or maybe only a hint for the right direction.
I've got a system that is separated into two applications. An existing VB.NET desktop client using Entity Framework 5 with code first ...
3
votes
2answers
200 views
Entity Framework and distributed Systems
I need some help or maybe only a hint for the right direction.
I've got a system that is sperated into two applications.
An existing VB.NET desktop client using Entity Framework 5 with code first ...
4
votes
2answers
427 views
Domain Logic in Service Layer exposed as WCF service
I am designing an enterprise solution which consists of modularized products within a product range using Entity Framework code first to define the domain model and provide the data access.
e.g. ...
1
vote
1answer
112 views
Is it feasible to change model relationship mappings and properties in Entity Framework CodeFirst at runtime?
Here's the situation. I have an enterprise application that uses EF Codefirst to map POCOs to an existing database. This has been working fine so far. In fact I would say that it's been working really ...
0
votes
2answers
725 views
Entity Framework designer not effective anymore
At my current workplace, Entity Framework 5 is used for all data access/manipulation.
It is a database-first approach using the model designer to add/edit/delete/update entities.
Problem
We now ...
3
votes
2answers
402 views
Sql Server Data Tools & Entity Framework - is there any synergy here?
Coming out of a project using Linq2Sql, I suspect that the next (bigger) one might push me into the arms of Entity Framework. I've done some reading-up on the subject, but what I haven't managed to ...
7
votes
3answers
659 views
Architecturally speaking, does a database abstraction layer, such as Microsoft's Entity Framework, void the need for a separate Data Access Layer?
The way it was
For years, I have organized my software solutions as such:
Data Access Layer (DAL) to abstract the business of accessing data
Business Logic Layer (BLL) to apply business rules to ...
0
votes
1answer
317 views
How I could update a DB table using a POCO class bound in a DataGridView
I try to explain better using an example:
I create the class Product with attibutes like that:
private string _ProductCode = "";
[DisplayName("ProductCode")]
public String ProductCode
{
get { ...
3
votes
2answers
509 views
Encapsulation in Domain Driven Design models?
I am using EF Code First and I had a model like below.
public class Account
{
[Required]
public string AccountNo { get; set; }
[Required]
public decimal Balance { get; set; }
}
I ...
4
votes
1answer
378 views
Does having more classes necessarily increase the memory requirements of the app?
When we add .edmx files to a DLL, the physical size of the DLL increases. DLL's are loaded into memory. However, the .NET infrastructure with functionality such as JIT compilation and the GAC ...
-2
votes
1answer
90 views
Advice on Giving Training on EF 5 [closed]
I have just joined a company in the capacity of a consultant on converting a Delphi based application to ASP.NET MVC. I am the only well experienced C# developer in the company, and my first task is ...
1
vote
4answers
744 views
Is Moving Entity Framework objects over a webservice really the best way?
I've inherited a .NET project that has close to 2 thousand clients out in the field that need to push data periodically up to a central repository. The clients wake up and attempt to push the data up ...
2
votes
4answers
566 views
ado.net or EF for a point-of-sale system
We have a point-of-sale system that was developed using ado.net, our current concern is to make the application real fast in creating transactions (sales). Usually there are no performance concerns ...
2
votes
3answers
681 views
what's a good approach to working with multiple databases?
I'm working on a project that has its own database call it InternalDb, but also it queries two other databases, call them ExternalDb1 and ExternalDb2. Both ExternalDb1 and ExternalDb2 are actually ...
