Advertisement
ArCiGo

Model.cs

Feb 17th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.57 KB | None | 0 0
  1. /* ../Models/Model.css */
  2.  
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Web;
  7. using FirebirdSql.Data.FirebirdClient;
  8. using System.Data.Entity;
  9. using System.Text;
  10. using System.Threading.Tasks;
  11.  
  12. namespace ConsultasEjecutivas
  13. {
  14.     public class SAEContext : DbContext
  15.     {
  16.         public string TableName { get; set; }
  17.  
  18.         public SAEContext(string connectionString, string tableName)
  19.             : base(new FbConnection(connectionString), true)
  20.         {
  21.             this.TableName = tableName;
  22.         }
  23.  
  24.         protected override void OnModelCreating(DbModelBuilder modelBuilder)
  25.         {
  26.             base.OnModelCreating(modelBuilder);
  27.  
  28.             var monDatabaseConfiguration = modelBuilder.Entity<Producto>();
  29.             monDatabaseConfiguration.HasKey(x => x.ClaveArticulo);
  30.             monDatabaseConfiguration.Property(x => x.ClaveArticulo).HasColumnName("CVE_ART");
  31.             monDatabaseConfiguration.Property(x => x.Descripcion).HasColumnName("DESCR");
  32.             monDatabaseConfiguration.Property(x => x.LineaProducto).HasColumnName("LIN_PROD");
  33.             monDatabaseConfiguration.Property(x => x.UltimoCosto).HasColumnName("ULT_COSTO");
  34.             monDatabaseConfiguration.ToTable(TableName);
  35.         }
  36.  
  37.         public DbSet<Producto> Productos { get; set; }
  38.     }
  39.  
  40.     public class Producto
  41.     {
  42.         public string ClaveArticulo { get; set; }
  43.         public string Descripcion { get; set; }
  44.         public string LineaProducto { get; set; }
  45.         public decimal UltimoCosto { get; set; }
  46.     }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement