9
I am using Entity Framework 4.4 code first(Factory Pattern) to get data from existing Oracle view. Here is my entity class:
class Data
{
[Required]
[StringLength(50)]
public String EmailAddress { get; set; }
[Required]
[StringLength(200)]
public String FundName { get; set; }
[Required]
[DecimalPrecision(AllowedPrecision=15,AllowedScale=0)]
public Decimal FundCode { get; set; }
[StringLength(3)]
public String BankCode { get; set; }
}
Here is my Map class
class DataMap : EntityTypeConfiguration<Data>
{
public DataMap() : base()
{
// Properties
Property(t => t.EmailAddress).HasColumnType("varchar2");
Property(t => t.FundName;
Property(t => t.FundCode
Property(t => t.BankCode).HasColumnType("varchar2");
// Table
ToTable("VIEW_FD_EMAIL");
}
}
Here is my context class
class OracleContext : DbContext
{
static OracleDataEntities()
{
//Database.SetInitializer<DataEntities>(new SeedingIntitializer());
Database.SetInitializer<OracleContext>(null);
}
public OracleDataEntities()
: base(new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString), true)
{
Configuration.ProxyCreationEnabled = false;
}
public DbSet<Data> MasterFund { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove<ColumnTypeCasingConvention>();
modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
modelBuilder.Conventions.Remove<IncludeMetadataConvention>();
base.OnModelCreating(modelBuilder);
modelBuilder.Configurations.Add(new DataMap());
}
}
Now while I am writing this line in test class-
var rep