I'm using EF6 Code First. Say, I have a table called "Consumer" with two columns:
1) Id, int, primary key, not null
2) Value, decimal(2,1), null
I have the following code for Consumer class:
Class Consumer
Overridable Property Id As String
Overridable Property Value As Decimal
End Class
And here's configuration for this class:
Class ConsumerConfiguration : Inherits EntityTypeConfiguration(Of Consumer)
Sub New()
With Me
.ToTable("Consumer")
.Property(Function(p) p.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None)
.Property(Function(p) p.Value).IsOptional()
End With
End Sub
End Class
Then I write test code:
Sub TestCodeFirst(connString As String)
db = New FLContext(connString)
db.Database.Initialize(True)
Console.Write("Adding new consumer... ")
db.Consumers.Add(New Consumer With {.Id = "032001801000175000099"})
db.Database.ExecuteSqlCommand("insert into dbo.Consumer(Id) values ('123456789012345678901');")
db.SaveChanges()
Console.WriteLine("Added!")
End Sub
As you see, I insert two rows: one is through DbContext, and the other is through raw SQL.
All works good. But to my surprise, when I execute query in SQL Server (SELECT * FROM dbo.Consumer), the value of "Value" column is "0.0" for the row inserted by DbContext, and NULL for the row inserted by raw SQL. Is it bug or I do something wrong?
P.S. The same thing happens in EF5.
P.P.S. If the type of Value column would be char, then inserting a row through DbContext would show NULL, as expected.
There is no knowledge that is not power.
