Retrieve IDENTITY

Question

Retrieve IDENTITY

Navigation

#1 by (0 votes)

0

Dear I have a problem that I was looking for I did not find a solution, I have the following tables in sql server 2008

and I have an application in Visual studio 2017, from WinForms WEB, with my connection to my database through CODE FIRST FROM DATABASE, so I automatically create the classes etc,

Now I have a form where I input data from the car, and by means of a FileUpload multiple, I upload several images,

What I already have echo is to have a LIST with all the routes of the images of the FILEUPLOAD, so my idea is to create the car with all its data and followed by that to make an insert in the table images with all the routes of my list but I do not know how to recover the ID of the car previously created, I hope someone enlightens me, thank you already

I insert them by means of the following syntax

var auto = new Automovil { Anio = titulo6 };
                db.Automovil.Add(auto);
                db.SaveChanges();

So then when creating the image, how do I know what ID the previous Automobile created?

c# visual-studio sql-server-2008 visual-studio-2017

asked by Bruno Sosa Fast Tag 15.09.2017 в 22:01

source

1 answer

close Jframe without closing all the windows Status: Failure: Failure to test: I / O error: The Network Adapter could not establish the connection

score 0 · Accepted Answer

It's already solved, I solved it like that,

var auto = new Automovil { Marca = "prueba1" };
                db.Automovil.Add(auto);
            db.SaveChanges();


            var imagen = new Imagenes { Automovil = auto.IdentificadorAutomovil };
            db.Imagenes.Add(imagen);
            db.SaveChanges();