Dataset query showing last created ID giving error

Question

I’m making a people registration form which when I finish entering the data it shows a MessageBox telling which ID the person was registered with. For that I use a query of my dataset(I’m using Entity Framework model first), but for some reason I’m making an error that "One or more lines contain values that violate non-null, Unique or Foreign-key restrictions." because I think it’s a mistake in the bank code, maybe not.

Follow the query code:

SELECT MAX(ID_Pacientes) as UltimoID FROM Pacientes_TCC

The field ID_Pacientes is autro increment and is a primary key.

Code where I implement the query:

 private void btnInserir_Click(object sender, EventArgs e)
        {

            Pacientes_TCCTableAdapter TaPaciente = new Pacientes_TCCTableAdapter();

            TaPaciente.Insert(txtNome.Text, txtCPF.Text, txtRG.Text, cbxSexo.Text, dtpData.Value, txtCidade.Text, txtEstado.Text, txtBairro.Text, txtCEP.Text,
                txtRua.Text, txtNumero.Text, txtCelular.Text, txtFixo.Text, txtEmail.Text, cbxConvenio.Text);

            if (MessageBox.Show("Pessoa gravado com o ID" +TaPaciente.UltimoID()+ " Deseja fazer outro cadastro?", "Confirma", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                Close();
            }



        }