Entity Framework 6 - Knowledge Base (KB)
118 results in tag: database
Why is a metadata property required for an Entity Framework Connection?
I switched my DAL from using LINQ over to Entity Framework. Because my application connects to different databases depending on the current user, I need to dynamically create the DataContext at run time and pass in the appropriate connection string. How...
asked by John Bubriski
In Linq to SQL with Entity Framework, how do you compare solely Date without Time in DateTime types?
Is there a way to compare two ...DateTime... variables in ...Linq2Sql... but to disregard the Time part....The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself....I want to co...
asked by Sruly
LINQ to Entities bulk deletion
Is there any way to bulk-delete a bunch of objects matching a given query in LINQ or LINQ-to-Entities? The only references that I can find are outdated, and it seems silly to iterate over and manually delete all objects I wish to remove.
asked by Benjamin Pollack
How can I COUNT rows in EntityFramework without having to load the contents?
I'm trying to determine how to ...count... the matching rows on a table using the EntityFramework....The problem is that each row might have many megabytes of data (in a Binary field). Of course the SQL would be something like this:...SELECT COUNT(*) FRO...
asked by NVRAM
How can I alter the Entity Framework database schema (mysql database)?
I use EntityFramework in a project to connect to a Mysql database. The provider is Devart Dot.connect....This application needs to connect to a database using connexion parameters given by the user at runtime. This includes of course the Mysql Database na...
asked by pierre
Entity Framework vendors for different databases are shown below.
Which providers are there and your experience using them...I would like to know about all possible native .NET Framework Entity Framework providers that are out there as well as their limitations compared to the default ...LINQ2Entities... (from MS for MS...
asked by Robert Koritnik
OLE DB Access Data Source using ADO.NET Entity Framework
Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an Access database that for various reasons can't be upsized to SQL....This MSDN page... says:...The .NET Framework includ...
asked by Tim Long
Entity Framework - database object refresh
I'm having trouble with refreshing objects in my database. I have an two PC's and two applications....On the first PC, there's an application which communicates with my database and adds some data to Measurements table. On my other PC, there's an applicat...
asked by Nebojsa Veron
The best SQL Server storage pattern for (product) characteristics
We are starting a new project where we need to store product and many product attributes in a database. The technology stack is MS SQL 2008 and Entity Framework 4.0 / LINQ for data access....The products (and Products Table) are pretty straightforward (a...
asked by EdH
In the foreach loop, use DeleteObject().
With Entity Framework, I try to delete some objects from my object context like that :...foreach (var item in context.Items.Where( i => i.Value > 50 ) ) { context.Items.DeleteObject(item); } ...With this code, I have a "Collection Was Modified" Excepti...
asked by Patrice Pezillier
Connection Pooling and Entity Framework
I've recently started to use the Entity Framework 4.0 in my .NET 4.0 application and am curious about a few things relating to pooling....Connection pooling as I know is managed by the ADO.NET data provider, in my case that of MS SQL server. Does this app...
asked by Noldorin
InvalidOperationException is thrown by EF4 Code-First.
I'm having an issue when trying to run my project each time it builds. It seems the initializer runs, but when it comes to the first query - it dies with the following ...InvalidOperationException.......This operation requires a connection to the 'master'...
asked by Amadiere
.NET Entity Framework ORM for PHP
I'm a .NET developer and new in PHP. I want to know, is there a ORM for PHP like the Entity Framework in the Microsoft .NET Framework? ...Are there any utility applications to make working with data faster and easier?
asked by Jalal
database schema design for thread messaging system
I'm trying to achieve exactly what's explained here: ...Creating a threaded private messaging system like facebook and gmail..., however i don't completly understand Joel Brown's answer. can any one please explain....This is what my db tables look like ...
asked by ShaneKm
In Entity Framework, map a string column to an Enum.
Is there a way to map a string column to an enum in an Entity Model?...I have done this in Hibernate, but can't figure it out in EMF.
asked by Sheldon Warkentin
Views in the Code First Entity Framework
How can I use the database view in entity framework code first,
asked by Sagar
In Entity Framework, how do I create a database from an.edmx file?
I have had to suddenly switch to working on Code First Entity Framework 4.1. I started off not knowing anything about this framework but in the last 8 hrs I am now much more comfortable having read blogs and articles....This blog in particular... is one o...
asked by Red Swan
How do I migrate a database using Entity Framework 4.2?
I'm just starting to dive into ASP.net MVC3. I come from a Django background. One of the things I love about Django, is the add-on called "South". It lets me modify my Models in code, and then I run a command, it figures out what has changed, and it updat...
asked by mpen
Create New Record in MVC Controller
I am using c# MVC I am trying to create 2 new records in 2 tables - employee and address table. I have the following so far:... db.employee.AddObject(empmodel.employee); db.address.AddObject(empmodel.address); db.SaveChanges(); ...When an empl...
asked by Nate Pet
There is already a database with the same name, or the supplied file cannot be accessed, or it is on a UNC share. What does this imply?
I Build an ASP.NET project with PL,BL,DAl, BE of Entity Data Model(=.edmx) which I generated from a service Based DB (= .mdf) which is located in my DAL project....I did copied the connectionString from the BE app.config to the PL web.config...what's wron...
asked by Rinacom
