Entity Framework Code First – No Detach() method on DbContext
For people that might stumble upon this question, as of CTP5 you now need to write ((IObjectContextAdapter)context).ObjectContext in order to get to ObjectContext.
code-first
Entity Framework – Is there a way to automatically eager-load child entities without Include()?
No you cannot do that in mapping. Typical workaround is simple extension method: public static IQueryable<Car> BuildCar(this IQueryable<Car> query) { return query.Include(x => x.Wheels) .Include(x => x.Doors) .Include(x => x.Engine) .Include(x => x.Bumper) .Include(x => x.Windows); } Now every time you want to query Car with all relations you will just do: var query = … Read more
How to remove child one to many related records in EF code first database?
In EF6 a faster way to do the operation is… context.Children.RemoveRange(parent.Children)
CREATE DATABASE permission denied in database ‘master’ (EF code-first)
I had the same problem. This what worked for me: Go to SQL Server Management Studio and run it as Administrator. Choose Security -> Then Logins Choose the usernames or whatever users that will access your database under the Logins and Double Click it. Give them a Server Roles that will give them credentials to … Read more
Entity Framework Code First Date field creation
Try to use ColumnAttribute from System.ComponentModel.DataAnnotations (defined in EntityFramework.dll): [Column(TypeName=”Date”)] public DateTime ReportDate { get; set; }
How can I disable code first migrations
set the Database.SetInitializer to null. public class DatabaseContext: DbContext { //the base accepts the name of the connection string provided in the web.config as a parameter public DatabaseContext() : base(“DatabaseContext”) { //disable initializer Database.SetInitializer<DatabaseContext>(null); }
Nullable property to entity field, Entity Framework through Code First
Just omit the [Required] attribute from the string somefield property. This will make it create a NULLable column in the db. To make int types allow NULLs in the database, they must be declared as nullable ints in the model: // an int can never be null, so it will be created as NOT NULL … Read more
ALTER TABLE DROP COLUMN failed because one or more objects access this column
You must remove the constraints from the column before removing the column. The name you are referencing is a default constraint. e.g. alter table CompanyTransactions drop constraint [df__CompanyTr__Creat__0cdae408]; alter table CompanyTransactions drop column [Created];
how to use views in code first entity framework [closed]
If, like me, you are interested only in mapping entity coming from an other database (an erp in my case) to relate them to entities specific of your application, then you can use the views as you use a table (map the view in the same way!). Obviously, if you try to update that entities, … Read more
How to specify table name with Entity Framework Code First Fluent API
You can also use the Table annotation: [Table(“InternalBlogs”)] public class Blog See: Code First Data Annotations