ASP.NET MVC Entity - Scaffolding for more than one table simultaneously

Question

I saw that an ASP.NET MVC project with C# has 2 magic tools that are Entityframework and Scaffolding. With them it is possible in a few minutes to have all the features of registration with in the database. Just bring the templates with Entity and then create a controller with scaffolding. Right? Good this is great for direct and simple registrations. But what if I want to insert in two or more related tables simultaneously in my bank? Example: Is it possible, with the same ease I create the INSERT/UPDATE, etc for these 3 tables in a single form? A single page where I fill all the fields click 1 button and tharam! I do the Insert in the 3 tables. Something similar to:

SELECT dbo.Tab_Aluno.*, dbo.Tab_Pessoa_Fisica.*, dbo.Tab_Contato.*
FROM dbo.Tab_Pessoa_Fisica 
INNER JOIN dbo.Tab_Contato ON dbo.Tab_Pessoa_Fisica.Id_Contato = dbo.Tab_Contato.Id 
INNER JOIN dbo.Tab_Aluno ON dbo.Tab_Pessoa_Fisica.Id = dbo.Tab_Aluno.Id_Pessoa_Fisica

The model would be:

public class CadastroAluno
    {
        public int CPF { get; set; }
        public string Nome { get; set; }
        public string Sexo { get; set; }
        public DateTime DataDeNascimento { get; set; }
        public string ContatoPrincipal { get; set; }
        public string TelefonePrincipal { get; set; }
        public string TelefoneSecundario { get; set; }
        public string Email { get; set; }
        public int Matricula { get; set; }
        public byte Foto { get; set; }
        public DateTime DataMatricula { get; set; }
        public string Status { get; set; }
    }

Answer 1

Supposing in your model, in the class PessoaFisica own a property Contato, you can add everything at once, so the Entity will handle the transaction for you in case of an error in one of the inserts, won’t save anything, it’s safer

public class Contato
{
    public int Id { get; set; }
    public string ContatoPricipal { get; set; }
    public string Email { get; set; }
    public string Telefone_Principal { get; set; }
    public string Telefone_Secundario { get; set; }
}

public class PessoaFisica
{
    public int Id { get; set; }
    public string Cpf { get; set; }
    public DateTime Dt_Nascimento { get; set; }

    public int ContatoId { get; set; }
    public Contato Contato { get; set; }
}

At this stage, by creating the object of PessoaFisica is already added the Contato, there call the SaveChanges(), both objects will be added and already related

using (var ctx = new SeuContexto())
{
    var pessoaF = new PessoaFisica
    {
        Cpf = "848.588.866-85",
        Dt_Nascimento = DateTime.Now,
        Contato = new Contato
        {
            ContatoPricipal = "sei la",
            Email = "[email protected]",
            Telefone_Principal = "99999999",
            Telefone_Secundario = "8888888",

        }
    };
    ctx.PessoaFisica.Add(pessoaF);
    ctx.SaveChanges();
}

Answer 2

You would save your data like this;

using (var ctx = new stackoverflowEntities())
{
    var contato = new Contato();
    contato.ContatoPricipal = "sei la";
    contato.Email = "[email protected]";
    contato.Telefone_Principal = "99999999";
    contato.Telefone_Secundario = "8888888";

    ctx.Contato.Add(contato);
    ctx.SaveChanges();

    var pessoaF = new PessoaFisica();
    pessoaF.cpf = "848.588.866-85";
    pessoaF.Dt_Nascimento = DateTime.Now;
    pessoaF.ContatoId = contato.ContatoId; // aqui ta a magica .... 

    ctx.PessoaFisica.Add(pessoaF);
    ctx.SaveChanges();

}

First you save the Contact and then after doing Savechanges the context stores the id that was generated then you use for the tables that have dependency on it.