Entity Framework 6 - Knowledge Base (KB)
163 results in tag: code-first
How to Get Parent Object with All Its Children in Entity Framework 4.0 using Code-First and POCO?
I'm new to EF 4.0, so maybe this is an easy question. I've got VS2010 RC and the latest EF CTP. I'm trying to implement the "Foreign Keys" code-first example on the EF Team's Design Blog, ...http://blogs.msdn.com/efdesign/archive/2009/10/12/code-only-furt...
asked by SirEel
First, the EF code - composite key
I have a legacy database which has two collumns and I want to map them as 1 ID is this possible...for example... public class Product { public string ProductID {get;set;} public string ShortDescription {get;set;} public string UserName {get;set;} } ..
asked by server info
Code First Custom Database Initializer (Entity Framework CTP 4)
I would like to implement a custom database initialization strategy so that I can generate the database schema and apply it to an EXISTING EMPTY SQL database using a supplied User ID and Password. ...Unfortunately the built-in strategies don’t provide w...
asked by Mark
Connection string for Entity Framework Code First in SQL Server Express
I am working in Visual Web Developer 2010 Express, and using the Entity Framework code-first CTP. I am able to do this with the new SQL Server CE but I am unable to find a connection string to work with SQL Server Express....This one, using the SQL Server...
asked by GilShalit
No Detach() function on DbContext in Entity Framework code first
I'm wondering why there is no Detach method on the DbContext object like there is for ObjectContext. Â I can only assume this omission was intentional, but I have a hard time figuring out why. Â I need to be able to detach and re-attach entities (for putt...
asked by Brian Sullivan
What happened to my DbContext DbSet?
I created a new Entity Frameworks Code First app and the DbSet (People) is returning null....public class Person { public int Id { get; set; } public string Name { get; set; } } public class Repository : DbContext { public DbSet<Person> Peopl...
asked by Jamey McElveen
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
Entity Framework Code First has a unique constraint.
Question...Is it possible to define a unique constraint on a property using either the fluent syntax or an attribute? If not, what are the workarounds?...I have a user class with a primary key, but I would like to make sure the email address is also uniqu...
asked by kim3er
To see an attached object as modified, force EF 4.1 code to run first.
All the examples I've found refer to a class called ObjectContext, which doesn't appear to exist in CTP5. I must stress at this point, CTP5 is my first exposure to the Entity Framework....I have a disconnected POCO that I have attached to my DbContext. Sa...
asked by kim3er
EF Code First and SQLite
After my success using SQLite with NHibernate, I am very happy to use it for testing with Entity Framework Code First....If you have some example connections string and set up demos, that would be great and save a bit of time from my hectic day....Thanks ...
asked by nick
how to use Code-First to annotate a parent-child connection
When using the CTP 5 of Entity Framework code-first library (as announced ...here...) I'm trying to create a class that maps to a very simple hierarchy table....Here's the SQL that builds the table:...CREATE TABLE [dbo].[People] ( Id uniqueidentifier no...
asked by Ralph Shillington
Using Entity Framework ExecuteStoreQuery to return a DataTable
I am working with a system that has many stored procedures that need to be displayed. Creating entities for each of my objects is not practical. ...Is it possible and how would I return a ...DataTable... using ...ExecuteStoreQuery... ?...public ObjectResu...
asked by detroitpro
On database creation, how do I input data in Entity Framework code first?
I'm using code first entity framework and I would like to know how to run some code when the database is being created so that I can populate my database with some data. (note that I'm asking for on database creation, not everytime the application starts)...
asked by ajma
When dealing with "EF-Code First," how can I define Keys?
I get a ModelValidationException (at the bottom) when working with "EF-Code First". It wants me to define a Key but I'm not sure what exactly it means......public class Unit { Guid id; String public_id; String name; bool deleted; }...
asked by gingerbreadboy
DateTime and UTC in Entity Framework
Is it possible to have Entity Framework (I am using the Code First Approach with CTP5 currently) store all DateTime values as UTC in the database?...Or is there maybe a way to specify it in the mapping, for example in this one for the last_login column:..
asked by Fionn
ProviderManifestToken configuration for EF Code First
I have a asp.net MVC3 project using EF code-first. For my unit testing I have been using SQL Server CE 4.0 and SQL Server 2008 Express. Both have worked perfectly with EF generating my database as expected....However, when I run my application outside of ...
asked by trevorc
First, foreign keys/objects should not be saved in Entity Framework code.
I have three classes, like so:...[DataContract] public class ApplicationDto : BusinessBase<int> { /// <summary> /// Gets or sets the name. /// </summary> /// <value>The name.</value> [DataMember] public string Name { get; set; } ...
asked by MartinHN
From the EF Code-First DbContext class, create a SQL CE database.
I've defined a set of classes in the style of Entity Framework Code-First conventions and annotated the class properties with System.ComponentModel.DataAnnotations attributes....Now I want to generate a SQL Server Compact Edition (SCSE) (4.0) database fro...
asked by Bent Rasmussen
Is stored procedures supported by Entity Framework Code First?
I've watched several presentations of EF Code First and haven't seen how EFCF works with stored procedures....How can I declare a method that will use some sp? Can I pass an entity to a method that calls sp without manually mapping entity properties to sp...
asked by frennky
How can I use Entity Framework code to update a row first?
How should I go about updating a row in the database? There is no update method, and if I use add and the primary key id already exists, I get an exception. Please provide an example if possible.
asked by Ryan
