I'm working on my first .NET project (.NET 3.5, ADO.NET and C#). We've built our entity models and are trying to build a clean business objects layer.
We've got our basic entity model and we want to add certain business-level semantics to the…
I have an ADO.NET Entity Data Model created. Everything worked fine, until I added new table in my database. So I wanted to add that table to my data model. I followed these steps: Right click on my model -> Update From Database. Than the wizard…
I know how to mark a group of fields as primary key in ADO.NET entities but i haven't found a way to declare unique constraints or check constraints.
Is this feature missing on the designer or on the framework?
Apart from auto mapping CLR Classes to EDM models, what are the advantages or use-cases for the ODataConventionModelBuilder ?
What specific set of pains does it make go away? With sample code if possible.
I have generated my POCO entities using POCO Generator, I have more than 150+ tables in my database.
I am sharing POCO entities all across the application layers including the client. I have disabled both LazyLoading and ProxyCreation in my…
I've just finished going through the MvcMusicStore tutorial found here. It's an excellent tutorial with working source code. One of my favorite MVC v2 tutorials so far.
That tutorial is my first introduction to using ADO.NET Entity Framework and I…
So I am trying to create my ADO Entity data model, and i cant seem to get past the "choose your data connection" page. I choose the correct connection, then click either no or yes for sensitive data, and i click next. However, nothing appears. …
I was wondering if it was wise to cache the Entity Framework's ObjectContext object in the Cache; will this give me issues with multiple connections at the same time that the user will experience issues with that?
I've gotten errors like:…
I have used Entity Framework to generate models for database before. The thing is that Entity Framework generate the model for a specific provider (SQL Server, Oracle, etc ..). How can I generate a model that may work with many providers.
I thought…
I have a project in visual studio ultimate 2010 (MVVM) and database, in SQLITE.
Everything worked fine, but now I have a problem with the ADO.NET Entity Data Model.
I searched for information about this and have not found much .. Every time I want…
in our current project we are using ADO.NET Entity Framework as data layer for the application. There are some tasks which require to run in a transaction because there's a lot of work to do in the database. I am using a TransactionScope to surround…
Suppose I have a database named MyDatabase which has two tables - MyTable1 and MyTable2. Using the Code First approach with Entity Framework 4.x and .NET 4, I have generated a context named MyDatabaseContext which contains MyTable1s and…
I am developing a website in ASP.NET MVC in Visual Studio. I'm trying to add a Database connection, but it gives me the error "The system cannot find the path specified".
Here's what I am doing:
Right Click on Models Folder
New Item > ADO.NET…