static void Main(string[] args) { Aluno a = new Aluno(); a.Numero = 1111; a.Nome = "zeca"; a.Interesses = new List<AlunoInteresse>(); var ai = new AlunoInteresse(); ai.Numero = a.Numero; ai.Interesse = "i1"; a.Interesses.Add(ai); ai = new AlunoInteresse(); ai.Numero = a.Numero; ai.Interesse = "i2"; a.Interesses.Add(ai); Aluno a1 = new Aluno(); a1.Numero = 2222; a1.Nome = "rita"; a1.Interesses = new List<AlunoInteresse>(); ai = new AlunoInteresse(); ai.Numero = a1.Numero; ai.Interesse = "i2"; a1.Interesses.Add(ai); ai = new AlunoInteresse(); ai.Numero = a1.Numero; ai.Interesse = "i3"; a1.Interesses.Add(ai); using (var ts = new TransactionScope()) { IDAOAluno dao = new DAOAluno(); try { dao.Create(a); dao.Create(a1); } catch (SqlException ex) { Console.Error.WriteLine(ex.GetType().Name+":"+ex.Message); Environment.Exit(-1); } ts.Complete(); } }
static void Main(string[] args) { Aluno a = new Aluno(); a.Numero = 1111; a.Nome = "zeca"; a.Interesses = new List<AlunoInteresse>(); var ai = new AlunoInteresse(); ai.Numero = a.Numero; ai.Interesse = "i1"; a.Interesses.Add(ai); ai = new AlunoInteresse(); ai.Numero = a.Numero; ai.Interesse = "i2"; a.Interesses.Add(ai); Aluno a1 = new Aluno(); a1.Numero = 2222; a1.Nome = "rita"; a1.Interesses = new List<AlunoInteresse>(); ai = new AlunoInteresse(); ai.Numero = a1.Numero; ai.Interesse = "i2"; a1.Interesses.Add(ai); ai = new AlunoInteresse(); ai.Numero = a1.Numero; ai.Interesse = "i3"; a1.Interesses.Add(ai); using (var ts = new TransactionScope()) { IDAOAluno dao = new DAOAluno(); dao.Create(a); dao.Create(a1); ts.Complete(); } }
public void Create(Aluno a) { using (var ts = new TransactionScope(TransactionScopeOption.Required) ) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO ALUNOS (NumAl,Nome) VALUES(@NumAl,@Nome)"; SqlParameter p1 = new SqlParameter("@NumAl", a.Numero); SqlParameter p2 = new SqlParameter("@Nome", a.Nome); cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); using (var cn = new SqlConnection(cs)) { cmd.Connection = cn; cn.Open(); cmd.ExecuteNonQuery(); if (a.Interesses != null) { var daoI = new DAOAlunoInteresse(); foreach (var interesse in a.Interesses) { daoI.Create(interesse); } } } ts.Complete(); } }
public void Update(Aluno a) { }
public void Delete(Aluno a) { }