Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Data.Entity;
- using System.Data.Entity.ModelConfiguration;
- using System.Collections; //Pt. ModelBuilder
- namespace CodeFirstSample
- {
- public class Clasa
- {
- public int ClasaId { get; set; }
- public string NumeClasa { get; set; }
- public virtual ICollection Elevi { get; set; }
- }
- public class Elev
- {
- public int ElevId { get; set; }
- public string Nume { get; set; }
- public string Prenume { get; set; }
- public int ClasaId { get; set; }
- public virtual Clasa Clasa { get; set; }
- }
- public class ScoalaContext : DbContext
- {
- public ScoalaContext()
- : base("Server=tcp:mysrvname.database.windows.net;" +
- "Database=MyDbName;" +
- "User ID=myuser;Password=mypassword;" +
- "Trusted_Connection=False;Encrypt=True;" +
- "MultipleActiveResultSets=True") // optiune necesara doar pt. SQL Azure
- { }
- public DbSet<Clasa> Clase { get; set; }
- public DbSet<Elev> Elevi { get; set; }
- protected override void OnModelCreating(DbModelBuilder modelBuilder) //Optional
- {
- modelBuilder.Entity<Elev>()
- .Map(m => m.ToTable("Elevi", "MySchema"))
- .Property(m => m.ClasaId).IsOptional()
- ;
- modelBuilder.Entity<Clasa>()
- .Map(m => m.ToTable("Clase", "MySchema"));
- }
- }
- class Program
- {
- static void Main(string[] args)
- {
- using (var db = new ScoalaContext())
- {
- //Insereaza date de test in DB
- var clasa1 = new Clasa { NumeClasa = "Clasa I-a" };
- var clasa2 = new Clasa { NumeClasa = "Clasa a II-a" };
- db.Elevi.Add(new Elev
- {
- Nume = "Popescu",
- Prenume = "Gigel",
- Clasa = clasa2
- });
- db.Elevi.Add(new Elev
- {
- Nume = "Ionescu",
- Prenume = "Ana",
- Clasa = clasa1
- });
- db.Elevi.Add(new Elev
- {
- Nume = "Florescu",
- Prenume = "Ioana",
- Clasa = clasa2
- });
- db.SaveChanges();
- //Afiseaza datele din DB
- var totiElevii = from p in db.Elevi select p;
- Console.WriteLine("Elevi pe clase:");
- foreach (var elev in totiElevii)
- Console.WriteLine(" - {0} {1}, {2}, {3}", elev.ElevId, elev.Nume, elev.Prenume, elev.Clasa.NumeClasa);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement