Incorrect syntax near the keyword "Primary"

Question

I have this error message but i cannot find any wrongdoing, 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 escape it and indicate you mean the object named Primary.