>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"; > } > } > } > > >} >>