Entity Framework 6 - Knowledge Base (KB)
563 results for: in tag: ef-code-first
Decimal precision and scale in EF Code First
I'm experimenting with this code-first approach, but I'm find out now that a property of type System.Decimal gets mapped to a sql column of type decimal(18, 0). ...How do I set the precision of the database column?
asked by Dave Van den Eynde
How to declare one to one relationship using Entity Framework 4 Code First (POCO)
How to declare a one to one relationship using Entity Framework 4 Code First (POCO)?...I found ...this question (one-to-one relationships in Entity Framework 4) ..., but the article that the answer references was not useful (there is one line of code that...
asked by Paul Hiles
Why is my DbContext DbSet null?
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
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
EF4 Code First CTP5: Seed method no longer works
I had EF Code First CTP4 working fine, and I installed CTP5 today. Now, I get an exception when my database is repopulated....Here is my model:...public class Member { public Member() { DateCreated = DateTime.Now; DateUpdated = Da...
asked by Dave
Returning a DataTable using Entity Framework ExecuteStoreQuery
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
How do I populate data in Entity Framework code first on database creation?
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
How to store images using Entity Framework Code First CTP 5?
I'm just trying to figure out if there is a simple way to store and retrieve binary (file) data using EF Code First CTP 5? I would really like it to use the FILESTREAM type, but I'm really just looking for some way to make it work.
asked by Max Schmeling
How do I singularize my tables in EF Code First?
I prefer using singular nouns when naming my database tables. In EF code first however, the generated tables always are plural. My DbSets are pluralized which I believe is where EF is generating the names but I don't want to singularize these names as I...
asked by trevorc
What is the syntax for self referencing foreign keys in EF Code First?
I am trying to reference a foreign key from SpouseId to Id in the Contact table. What is the syntax for doing this? I can't seem to find an example. Thanks....I have a class like this:...public class Contact { public int Id {get;set;} public st...
asked by trevorc
Generate SQL CE database from EF Code-First DbContext class
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
How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
I'm working with the Code First feature of Entity Framework and I'm trying to figure out how I can specify the column data types that should be created when the database is auto-generated....I have a simple model:...public class Article { public int A...
asked by Mark Bell
The entity type <classname> is not part of the model for the current context
DB has a table ...PackagingInfo.... I have a ...Package... class, and a ...ShopEntities : DbContext.......// Entity (ex. Package.cs) [Table("PackagingInfo")] public class Package { public decimal PackageID { get; set; } public decimal Title { get;...
asked by maryam
Mocking or faking DbEntityEntry or creating a new DbEntityEntry
Following on the heels of my other ...question about mocking DbContext.Set... I've got another question about mocking EF Code First....I now have a method for my update that looks like:...if (entity == null) throw new ArgumentNullException("entity"); ...
asked by taylonr
EF Code first invalid column name "CategoryCategoryID"
There is a existing database named Northwind with a webform application. when running the application raise up a error: 'invalid column name CategoryCategoryID'. any one help me?. thanks in advance!!...Category.cs:...public class Category { public in...
asked by user441222
Entity Framework CTP5 Code First, WPF - MVVM modeling
I have my model all setup for my WPF application and working with entity framework ctp5 code first, here's a sample model class:...public class Task { public int ID { get; set; } public int Index { get; set; } public string Content { get; set;...
asked by Chris Klepeis
EF Code First CTP5, using Include method with Many to Many table
I have something like the following many to many relationship tables....public class Shop{ public int Id { get; set; } public virtual ICollection<ShopFacility> ShopFacilities { get; set; } } public class ShopFacility { public int Id { get; set; } ...
asked by Yoo Matsuo
Database in use error with Entity Framework 4 Code First
I have an MVC3 and EF 4 Code First application, which is configured to change the DB when the model changes, by setting the DB Initializer to a ...DropCreateDatabaseIfModelChanges<TocratesDb>..., where ...TocratesDb... is my derived ...DbContext.......I h...
asked by ProfK
Can code-first Entity Framework do cross database queries with SQL Server DBs on the same box?
I know there have been a lot of questions about Entity Framework doing cross database queries on the same server posted to ...stackoverflow.... Mostly the answer seems to be 'no', and this link from ...way back in 2008 is referenced.... However, Entity F...
asked by mattmc3
Difference between .WithMany() and .WithOptional()?
Below are two similar fluent API configurations:...WithMany()...modelBuilder.Entity<Country>() .HasRequired(cou => cou.Currency) .WithMany() .WillCascadeOnDelete(false); ...WithOptional()...modelBuilder.Entity<Country>...
asked by Ingmar
Page 1 of 29
