An ORM built by Microsoft and is available as part of .Net framework 3.5 and later.
0
votes
1answer
155 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
156 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 ...
2
votes
1answer
122 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 ...
5
votes
3answers
366 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
188 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
0answers
41 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 ...
3
votes
2answers
105 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
42 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
256 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 ...
2
votes
1answer
121 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
3answers
271 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
119 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
245 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
328 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
54 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
178 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
382 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
49 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
331 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
427 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
184 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
258 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
300 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
224 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
1k 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
347 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
250 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
218 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
179 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, ...
11
votes
4answers
1k 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
239 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
203 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
235 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
191 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
1k 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
940 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
1k 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
686 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
503 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
505 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
349 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
158 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
382 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
253 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
311 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 ...
4
votes
1answer
261 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
559 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 ...
