I am using EF4.0 with Oracle 11g.
Using MS EF (edmx) I cannot retrieve a column's default value so I tried Entity Developer producing a edml file. There I can see the default value in the respective properties, but how can I retrieve that value at runtime so that I can show it on a data entry form?
Read oracle table default value from entities.
Here is the code that obtains the default value from the conceptual metadata workspace:
Code: Select all
MetadataWorkspace workspace = context.MetadataWorkspace;
object value;
var item = ws.GetItems(DataSpace.CSpace).Where(i => i.Name == "MyEntity").Single();
value = item.Properties.Where(p=>p.Name == "MyProperty").Single().DefaultValue;