Just a quick question to see what others think is the best preactise...
You have an Windows application that connects to a SQL Server DB. You use a dataset to represent the database locally. Is it better to write queries locally in your dataset, or in SQL Server itself? In other words, do you write and save queries in your Visual Studio project, or in SQL Server and then copy them over as part of the dataset?
Hope that makes sense! I'd be intersted to know what others do.