Reputation: 132548
Can Entity Framework create Objects with default values for Non-Null columns?
I thought I saw something somewhere about being able to generate an object in EF with all the non-null values filled in with generic values.
I tried using context.CreateObject<MyEntity>(), however I am still getting errors about trying to save NULL data to a non-null column.
Was I mistaken in thinking this? Or do I just have the wrong syntax?
Upvotes: 3
Views: 1247
Answers (2)
Reputation: 57783
In the model designer, you can enter a default value on the property sheet for each field.
Upvotes: 3
Reputation: 13399
You can not save null data to a non-nullable column. If CreateObject method gives you that you'll need to change that before trying to save data. Also, watch out for DateTime objects, SQL server has different min value of that than the .NET.
Upvotes: 2
Related Questions
- Entity Framework Core: default value when migrating nullable column to required
- Entity Framework Core default values for missing columns
- Entity framework generates values for NOT NULL columns which has default defined in db
- Can I tell EF6 to not try and insert a value into a column if it's null and there's a default?
- How do I tell Entity Framework to allow SQL Server to provide a defined default value for a field?
- Entity Framework Code First - Default values on non-nullable types
- Is there an easy way to make EntityFramework use SQL default values?
- How can I have value types that map to nullable database columns in Entity Framework?
- Problem with non-nullable columns with default values in EF data model
- Entity Framework 4 and Default Values