ADO.NET Entity Framework abstracts the relational (logical) schema of the data that is stored in a database and presents its conceptual schema to the application. This abstraction eliminates the object-relational impedance mismatch that is otherwise common in conventional database-oriented programs. ...
-3
votes
0answers
24 views
Differents situations to validate data [closed]
I would like to know how to validate a product when it's added and to validate in a different way when I'm updating it. I tried to create two interfaces(IValidateInsert and IValidateUpdate) and ...
0
votes
3answers
106 views
Software design approach for large relational database
I am working on a personal side project that will utilize a complex and large relational database. During the design of the database I had some co-workers give advice to how I should approach my ...
1
vote
2answers
106 views
With entity framework - who needs a DAL
On EF4 actions on entities are actually done via the Business Element layer (BE).
Why do I need the Data Access (DAL) on another layer?
2
votes
2answers
51 views
Proper & Efficient Structure for an entity layer?
Context
Web application based on the .NET Framework written in C# and following the MVC design pattern.
Question
What is the most efficient way to structure an entity layer consisting on various ...
-1
votes
0answers
61 views
Lookup databinding (VS2010, Entity, WinForms) [closed]
Please help me.
1) Here you can see http://msdn.microsoft.com/en-us/library/ms233685.aspx phrase "3. Change the drop type of the child table to Details by selecting Details from the control list on ...
23
votes
3answers
2k views
Is Entity Framework Suitable For High-Traffic Websites?
Is Entity Framework 4 a good solution for a public website with potentially 1000 hits/second?
In my understanding EF is a viable solution for mostly smaller or intranet websites, but wouldn't scale ...
-1
votes
0answers
18 views
Delete Db element with EntityFrameWork [migrated]
I'm trying to implement a method that delete a element of a DB table.
The doesn't get any exception but the running code, the element still exists inside the table.
namespace SuitTest_tt_content_2
...
5
votes
3answers
3k views
In ASP.NET MVC3 controllers, where do you instantiate your DataContext?
In your ASP.NET MVC 3 applications that use a DataContext or DbContext, where do you instantiate your data access object?
Here is a non-exhaustive list of where I've seen it done:
Individually ...
9
votes
8answers
940 views
Is writing your own Data Access / Data Mapping Layer a “good” idea?
We're currently in a situation where we have a choice between using an out-of-the-box object-relational mapper or rolling our own
We have a legacy application (ASP.NET + SQL Server) where the ...
3
votes
3answers
636 views
Is the ADO.net Entity Framework appropriate when all you do is insert records in bulk?
My department develops software to migrate databases for our customers from their old CRM software to ours. In this process we could be inserting up do millions of rows, processed one at a time as we ...
2
votes
2answers
94 views
Is it considered best practice to dynamically bind return types from the Entity context?
MyDbEntities context = new MyDbEntities();
var result = context.StoredProcedureName(userId);
In the situation above, is it considered best practice to use var or ObjectResult<ComplexType>?
1
vote
3answers
132 views
How easy it is to update Entity Model from database when enough code has already been written?
I am new to Entity Framework.
I know there is an option to update model from the database, but I want to know how easy and successful is this task. I may need to update my model in a few weeks but ...
2
votes
2answers
166 views
Databinding to an Entity Framework in WPF
Is it good to use databinding to Entity Framework's Entity in WPF?
I created a singleton entity framework context:
To have only have 1 connection and it won't open and close all the time.
So I can ...
3
votes
6answers
222 views
Using XML field Vs. creating a table for unstable organization
I am in the middle of design an application to issue and store invoices for an organization. The problem is the organization is not stable at all. There are many types of invoices and they may ...
1
vote
1answer
261 views
Entity Framework and “ViewModel”
Earlier I asked a question about "Entity Framework and layer seperation" and found out that some people use a ViewModel to show their data in the UI.
For example if we got a "Person" table and an ...