SqlAzureDemoWithEF5

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);
            }
        }
    }

}