Entity Framework 6 - Knowledge Base (KB)
115 results for: in tag: database
Why does an Entity Framework Connection require a metadata property?
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
How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
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
Bulk-deleting in LINQ to Entities
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 to COUNT rows within EntityFramework without loading 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 to change the database - Schema used by Entity Framework (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
A list of Entity Framework providers for various databases
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
ADO.NET Entity Framework with OLE DB Access Data Source
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 - refresh objects from database
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
Best pattern for storing (product) attributes in SQL Server
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
DeleteObject() in foreach loop
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
Entity Framework and Connection Pooling
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
EF4 Code-First causes InvalidOperationException
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
ORM for PHP like .NET Entity Framework
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
thread messaging system database schema design
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
Map string column in Entity Framework to 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
how to use views in code first entity framework
How can I use the database view in entity framework code first,
asked by Sagar
How can I generate the database from .edmx file in Entity Framework?
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 can I perform database migration 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
MVC Controller Create New Record
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
A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. what does it means?
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
Page 1 of 6
