sql 插入后返回主键id写法

 StringBuilder sqlBuilder = new StringBuilder();
        sqlBuilder.Append("Insert into Students");
        sqlBuilder.Append("(StudentName,StudentIdNo,Gender,Birthday,CardNo,");
        sqlBuilder.Append("Age,PhoneNumber,StudentAddress,ClassId,StuImage)");
        sqlBuilder.Append(" values(@StudentName,@StudentIdNo,@Gender,@Birthday,");
        sqlBuilder.Append("@CardNo,@Age,@PhoneNumber,@StudentAddress,@ClassId,@StuImage)");
        sqlBuilder.Append(";select @@Identity");