Good day!

Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends.

While writing SQL for SqlCommand:

• Is it needed to quote field and table names with []?
• Is it good to prefix table names with [dbo]

I use to use this syntax:

SqlCommand command = new SqlCommand("SELECT [Field1], [Field2] FROM [dbo].[TableName]", connection);

May be there is a better way?

Thanks in advance!