public static void SetConfig() { var defaultLocation = new ConfigLocationHelper(); var sqlLoader = new FileSqlLoader(defaultLocation.SQLStatement); connDesc = DBContextHelper.Instance.getConfiguration(); dbManager = new PetaPocoContextManager(new[] { sqlLoader }, new[] { connDesc }); dbManager.SetContextExecutionMode(DBContextExecutionMode.ByName); }
//[TestMethod] public void TestMethod1() { IFileLoader loader = new FileSqlLoader("file-sql-loader", AppDomain.CurrentDomain.BaseDirectory + @"\App_Code\SqlFiles"); IDbManager dbManager = new Common.Database.Petapoco.PetapocoDbManager(null, null); //// initialize sql loader and connection descriptor dbManager.AddSqlLoader(loader); dbManager.ConnectionDescriptor.Add(new ConnectionDescriptor() { ConnectionString = @"DATA SOURCE=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = tcp)(HOST = batuampar.idbpn.chevronCommon.net)(PORT = 1521)))(CONNECT_DATA =(SID = ih10bpnd))); USER ID=MIMSWH; PASSWORD=mimswh4devel#2012;", IsDefault = true, ProviderName = "System.Data.OracleClient", Name = "MIMSWH" }); IDataCommand db = dbManager.GetDatabase("MIMSWH"); List <object> result = db.Query <object>("SELECT * FROM tddistrict", null); }