An ORM built by Microsoft and is available as part of .Net framework 3.5 and later.
0
votes
2answers
116 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 ...
1
vote
1answer
37 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 ...
5
votes
2answers
126 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 ...
1
vote
0answers
86 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 { ...
0
votes
2answers
81 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
298 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
37 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 ...
0
votes
0answers
10 views
Organizing namespaces in a 600+ DbSets DAL library
Recently I used some EF code-first reverse-engineering tool on a database, that gave me a DbContext with over 600 DbSets.
Only a small subset of the tables need to be used at a time, so I figured I'd ...
1
vote
4answers
108 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
293 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 ...
0
votes
0answers
37 views
Should I create a new entity for these attributes?
I'm writting a site where people will be able to write about movies and give their opinion and rating, a movie will have defined attributes to star-rate (one star,two ... 5 stars), like: general, ...
1
vote
2answers
223 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 ...
5
votes
1answer
264 views
Is Code First with Migrations or SQL Server Data Tools a better fit?
I have been given a spec to create a new MVC4 website, it will not be too large a project at first but I suspect it will grow as the business gets new ideas for it.
Using .NET 4.5 ASP.NET MVC4 and EF ...
1
vote
0answers
159 views
What is the rule on passing around collections? List vs. Ienumerable vs. IQueryable
I do Entity Framework stuff using repository patterns that are passed to the controller to than be called by the client using jquery AJAX.. Is there any basic rules on in what format I should be ...
2
votes
1answer
206 views
Is there value in learning Entity framework 4.0
I purchased a used book by Julia Lerman (2010) on EF4.0, and now I am wondering if the EF has changed dramatically since, I'm looking to learn this technology and i do not know if starting with a ...
1
vote
3answers
263 views
Is Entity Framework only for Asp .NET / Asp. NET MVC? [closed]
I never coded on VS and I'm a junior programmer in C# and I would like to know if the entity framework is available only for ASP .NET applications ?
1
vote
1answer
165 views
How do I split out a service layer
I currently have four projects in my website's solution:
Project.Data
This holds the EntityFramework DbContext object and also the Repositories that interact with it. It references Project.Models.
...
2
votes
2answers
731 views
Why should I use List<T> over IEnumerable<T>?
In my ASP.net MVC4 web application I use IEnumerables, trying to follow the mantra to program to the interface, not the implementation.
Return IEnumerable(Of Student)
vs
Return New List(Of ...
2
votes
2answers
276 views
Is there a better way to model a many-to-many relationship on the same table with Entity Framework?
The context
We're building a web application using Entity Framework 5.0. One of the requirements is that it should be possible for the administrators to link related products so that when someone ...
0
votes
2answers
228 views
Mapping a legacy database to ORM using wrapper classes
I want to use an ORM with a legacy database, but I don't want to expose some of the underlying data types. For example, some of the columns are nullable doubles or floats and I want my domain model to ...
0
votes
2answers
203 views
What is the equivalent of Entity Framework in the world of Oracle shops? [closed]
Within the world of developers/firms specializing in building/deploying solutions built around software built/sold by Oracle (aka "Oracle houses"), what ORM middleware is considered as the "industry ...
2
votes
0answers
154 views
Entity Framework design help
I'm after some advice as to whether I'm on the right track with what I'm doing. I'm developing a WPF app where I need to retrieve a large graph of entities, work on that graph in the UI (display, ...
8
votes
5answers
973 views
Should Repositories return IQueryable?
I have been seeing a lot of projects that have repositories that return instances of IQueryable. This allows additional filters and sorting can be performed on the IQueryable by other code, which ...
3
votes
1answer
232 views
Entity Framework eager loading/reference data
I'm struggling to get my head around how best to eager load entities, and how to assign relationships when creating new entities. I'm using EF5 POCO, by the way.
I'm retreiving a large hierarchy of ...
1
vote
2answers
1k views
ASP.NET MVC 4 with Entity Framework 5 and SimpleMembership integrated into Repository and Unit Of Work pattern
I have a ASP.NET MVC4 project in which I would like to use the SimpleMembership. The application has a Person table that holds relevant information about users in the system.
I would like a link ...
2
votes
1answer
179 views
Is it okay to convert dataset from stored procedure to IEnumerable
So, I am working on a project with a team and we are using Entity Framework. We basically want to use linq to entities, and not use stored procedures. I use quite a bit of lists and IEnumerables and ...
5
votes
1answer
209 views
Entity Framework as a type checking/verification system for database code
When I read pro and con lists of using Entity Framework (or any modern ORM really), I'm surprised that the following point doesn't arise (self quote):
Using strongly-typed domain entities allows ...
0
votes
0answers
171 views
Is it safe to add untracked entities to a DBSet?
I was thinking of ways to duplicate existing entities and possibly alter some of its properties. I have read a couple of articles describing how to achieve them by either using reflection or reading ...
0
votes
1answer
941 views
Layered architecture using Entity Framework with different class libraries
Our business requirements required to create a layered and modular architecture. So I designed an architecture to make it as decoupled and as modular as possible. I will list my layers below
ASP ...
2
votes
2answers
748 views
Is it better to create a stored procedure or entities to get to the data I need?
I just jumped into a new project with a new company using Entity Framework and ASP.NET MVC 4. I am no expert on Entity Framework, but I think I have a decent grasp of how to use it.
From what I can ...
11
votes
4answers
944 views
Is a Unique ID column needed in a many-to-many (junction) table?
Getting a few projects started with EF, but I had some questions about join tables and keys etc. Lets say I have a table of applications and a table of permissions. Applications have many permissions ...
2
votes
2answers
525 views
Different database for Membership and our web data or use just one?
Is better to keep our Membership stuff on the DefaultConnection and create another connection (another database) for our data? Or just one database for all?
If I have a MyAppContext and I want ...
3
votes
1answer
479 views
Where to put custom validation while using Entity Framework
I am using MVC3 and Enitty Framework 4 with the Database first approach. It created the context template with its own validation for the fields based on the database. My question is where should I put ...
5
votes
1answer
462 views
Architecture : am I doing things right?
I'm trying to use a '~classic' layered arch using .NET and Entity Framework. We are starting from a legacy database which is a little bit crappy:
Inconsistent naming
Unneeded views (view referencing ...
2
votes
1answer
1k views
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?
var numbers = new int[] { 1, 2, 3, 4, 5 };
var contacts = from c in context.Contacts
where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault()
...
0
votes
2answers
316 views
WCF an Entity Framework connection
I have a 100+ users on a Silverlight application that uses WCF and entity framework.
Everyone has their own database and here comes my problem.
How do I make sure that only the user gets access to ...
2
votes
1answer
141 views
Are elements returned by Linq-to-Entities query streamed from the DB one at the time or are they retrieved all at once?
Are elements returned by Linq-to-Entities query streamed from the database one at the time ( as they are requested ) or are they retrieved all at once:
SampleContext context = new ...
2
votes
4answers
341 views
What is the most effective order to learn SQL Server, LINQ, and Entity Framework?
I am trying to get some advice on what order I should learn about SQL Server, LINQ, and Entity Framework to be able to better work with ASP.NET Webforms and MVC.
From what I've been able to learn so ...
8
votes
3answers
2k views
How should I implement the repository pattern for complex object models?
Our data model has almost 200 classes that can be separated out into about a dozen functional areas. It would have been nice to use domains, but the separation isn't that clean and we can't change it. ...
6
votes
2answers
235 views
How far should an entity take care of its properties values by itself?
Let's consider the following example of a class, which is an entity that I'm using through Entity Framework.
- InvoiceHeader
- BilledAmount (property, decimal)
- PaidAmount (property, ...
0
votes
3answers
294 views
What's wrong performing unit test against concrete implementation if your frameworks are not going to change?
First a bit of background: We are re-architecting our product suite that was written 10 years ago and served its purpose. One thing that we cannot change is the database schema as we have 500+ client ...
3
votes
1answer
176 views
Possible to switch table at runtime using Entity Framework?
I have code to switch between databases when using EF, but now also need to allow the user to choose a particular table. (The tables all use the same schema but may have different names because of the ...
7
votes
1answer
508 views
Why is the use of the STE template no longer recommended for EF5?
I was looking to upgrade my project from EF4.1/Framework 4.0 to EF5/Framework 4.5. After reading up on migrating the t4 templates for STE's (Self-Tracking Entities), I came across this link that ...
21
votes
4answers
3k views
Entity Framework with large systems - how to divide models?
I'm working with a SQL Server database with 1000+ tables, another few hundred views, and several thousand stored procedures. We are looking to start using Entity Framework for our newer projects, and ...
11
votes
5answers
6k views
Is There a Real Advantage to Generic Repository?
Was reading through some articles on the advantages of creating Generic Repositories for a new app (example). The idea seems nice because it lets me use the same repository to do several things for ...
6
votes
2answers
3k views
Dependency injection with n-tier Entity Framework solution
I am currently designing an n-tier solution which is using Entity Framework 5 (.net 4) as its data access strategy, but am concerned about how to incorporate dependency injection to make it testable / ...
1
vote
2answers
906 views
Entity Framework Joining Tables With Ranged Foreign Key Relationships
I'm not sure if "Ranged Foreign Key Relationship" is an actual term or if I just made it up, but this is what I am talking about:
AgeGroup Table
int MinAge { get; set; }
int MaxAge { get; set; }
...
10
votes
5answers
8k views
Is Entity framework reliable enough to use in a Corporate Project? Should I use Entity? [closed]
I'm a junior developer who's just completed a project using Entity framework. Unfortunately I was chewed out by one of the Senior Developers at my work citing that I should have used ADO.net and that ...
4
votes
3answers
3k views
Is Entity framework reliable enough to use in a Corporate Project? Should I use Entity? [duplicate]
Possible Duplicate:
Is Entity framework reliable enough to use in a Corporate Project? Should I use Entity?
I'm a junior developer who's just completed a project using Entity framework. ...
3
votes
3answers
312 views
Why should I add CHECK CONSTRAINT?
Following is a table creating script created by Entity Framework using the model shown in http://codereview.stackexchange.com/questions/14077/is-it-proper-tpt-inheritance.
In this script, there are ...
