Advertisement
Guest User

Problem 1.Products Shop

a guest
Jul 25th, 2015
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.33 KB | None | 0 0
  1. namespace ProductShop.Data
  2. {
  3.     using System;
  4.     using System.Data.Entity;
  5.     using System.Linq;
  6.  
  7.     using ProductShop.Models;
  8.  
  9.     public class ProductShopContext : DbContext
  10.     {
  11.         public ProductShopContext()
  12.             : base("name=ProductShopContext")
  13.         {
  14.         }
  15.  
  16.         public virtual IDbSet<User> Users { get; set; }
  17.  
  18.         public virtual IDbSet<Category> Categories { get; set; }
  19.  
  20.         public virtual IDbSet<Product> Products { get; set; }
  21.  
  22.         protected override void OnModelCreating(DbModelBuilder modelBuilder)
  23.         {
  24.             modelBuilder.Entity<User>().HasMany(u => u.Friends).WithMany().Map(
  25.                 m =>
  26.                     {
  27.                         m.MapLeftKey("UserId");
  28.                         m.MapRightKey("FriendId");
  29.                         m.ToTable("UserFriends");
  30.                     });
  31.  
  32.             modelBuilder.Entity<User>()
  33.                 .HasMany(u => u.Products)
  34.                 .WithOptional(p => p.User).Map(m => { m.MapKey("BuyerId"); });
  35.  
  36.             modelBuilder.Entity<User>()
  37.                 .HasMany(u => u.Products)
  38.                 .WithRequired(p => p.User)
  39.                 .Map(m =>
  40.                 {
  41.                     m.MapKey("SellerId");
  42.                 });
  43.  
  44.             base.OnModelCreating(modelBuilder);
  45.         }
  46.     }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement