zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

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...
connection connection-string data-access-layer database entity-framework
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...
.net c# database entity-framework linq-to-sql
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.
c# database entity-framework linq linq-to-entities
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...
c# database entity-framework
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...
c# connection database entity-framework mysql
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...
.net database entity-framework orm provider
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...
ado.net database entity-framework ms-access provider
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...
database entity-framework objectcontext wpf
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...
database database-design entity-framework sql sql-server
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...
.net c# database entity-framework
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...
.net ado.net connection-pooling database entity-framework
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'...
c# code-first database ef-code-first entity-framework
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?
.net database entity-framework orm php
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 ...
asp.net database database-design entity-framework linq
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.
.net c# database entity-framework orm
asked by Sheldon Warkentin

Views in the Code First Entity Framework

How can I use the database view in entity framework code first,
.net code-first database entity-framework view
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...
auto-generate c# database edmx entity-framework
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...
asp.net-mvc-3 c# database entity-framework migration
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...
asp.net-mvc database entity-framework
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...
asp.net c# database entity-framework
asked by Rinacom

Page 1 of 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!