using System; namespace FuturePathDev.Sample.Business.SQLCommands { public class SQLQueries { public SQLQueries() { } } namespace CasesData { public class CasesSQL { public string GetAll() { return "select a.case_id, b.title, c.country," + "a.expir_date from patents a, cases b," + "country c where a.case_id = b.case_id and" + "a.country_id = c.country_id"; } public string GetByID(string pCaseID) { return "select case_id, title from cases " + "where case_id = '" + pCaseID + "'" ; } } } namespace PatentData { public class PatentsSQL { public string GetAllPatents() { return "select a.case_id from patents a"; } } } }Thanks Bonnie, Kevin, Neil