Incorrect syntax next to the keyword "Primary"

Question

I have this error message, but I can not find any errors, help?

const string sql = @"SELECT PrimarySchool,TopHonour,Cca,TopStudent,TopAggregate,TopImage FROM Primary"; 

Answer 1

primary is a reserved keyword in TSQL. Make it SELECT ...(snipped)... FROM [Primary]" to avoid it and indicate that you mean an object named Primary.