I’ll explain this by using examples in DDL ... Fortunately, there are database development tools that can generate correct SQL queries for you, often by dragging and dropping tables and fields ...

Having a POCO class makes it easy to add those methods, or others that you find useful. Any hint of dynamic T-SQL queries should ring warning bells for security minded developers. Dynamic queries are ...