Hello I hope you can help me I'm trying to get how many records my sql table has I have the following
public int ultimoRegistro()
{
var LastRecord = (from c in db.Alumnos
orderby c.IDAlumno descending
select c).First();
return LastRecord;
}
but I get an error in the data types
If I understand correctly, you want to get the last IDAlumno stored in the Alumnos table.
The problem with your code is that it is returning the entire entity Alumno , so it would be necessary to define which property to return.
Therefore, I return select c.IDAlumno .
For this, make the following code:
public int ultimoRegistro()
{
var LastRecord = (from c in db.Alumnos
orderby c.IDAlumno descending
select c.IDAlumno).First();
return LastRecord;
}
If you use EntityFramework, you can use this:
db.Alumnos.Max();
so you will get the last record by the Id.
To obtain the number of records in your table, you have to use the Count method in the following way:
public int ultimoRegistro()
{
var LastRecord = (from c in db.Alumnos
select c).Count();
return LastRecord;
}