/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0 ", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
public void CreateDB()
{
db = new Database(_connectionStringName);
db.OpenSharedConnection(); // <-- Wow, this is crucial to getting SqlCE to perform.
db.Execute(Utils.LoadTextResource(string.Format("PetaPoco.Tests.{0}_init.sql", _connectionStringName)));
}
private static Database HaveDb()
{
string message = "";
if ((UseFileSystem == false) && (_db == null))
{
InitDb();
string rootPath = IOManager.RootDirectory;
string dataPath = IOManager.Combine(rootPath, "App_Data");
if (ConnectionString.Contains("|DataDirectory|") == true)
{
ConnectionString = ConnectionString.Replace("|DataDirectory|", dataPath + IOManager.DirectorySeparator);
}
bool checkDb = true;
if ((ProviderNameFactory.ToUpper() == AppCommon.SQLiteProviderNameFactory.ToUpper()) && (ConnectionString.Contains("AutoFill") == false))
{
string sqliteDbPath = "";
int idxOfSemiColon =ConnectionString.IndexOf(";");
if (idxOfSemiColon > -1)
{
int idxOfEqual = ConnectionString.IndexOf("=");
sqliteDbPath = ConnectionString.Substring(idxOfEqual + 1, idxOfSemiColon - idxOfEqual -1);
}
else
{
sqliteDbPath = ConnectionString.Substring(ConnectionString.IndexOf("=") + 1);
}
if (IOManager.CachedFileExists(sqliteDbPath, true, true) ==false)
{
checkDb =false ;
LogManager.Log(LogLevel.Critical, "DataSource-HaveDb", "Sqlite Db Not found in Path [" + sqliteDbPath + "]");
}
}
if (checkDb == true)
{
_db = DataStore.HaveDb(ConnectionString, ProviderNameFactory, out message);
if (_db != null) {
_db.OnDBException -= new PetaPoco.DBException(OnDBException);
_db.OnDBException += new PetaPoco.DBException(OnDBException);
if (ProviderNameFactory == AppCommon.SQLiteProviderNameFactory)
{
_db.KeepConnectionAlive = true;
UseSharedConnection = true;
//_db.Execute("PRAGMA journal_mode=WAL;");
//_db.Execute("PRAGMA journal_mode=DELETE;");
}
if (ProviderNameFactory == AppCommon.MySQLProviderNameFactory)
{
_db.KeepConnectionAlive = false;
UseSharedConnection = false;
//_db.Execute("set wait_timeout=28800");
//_db.Execute("set interactive_timeout=28800");
//_db.Execute("set net_write_timeout=999");
}
if (UseSharedConnection == true)
{
_db.OpenSharedConnection();
}
}
}
}
if (_db == null) {
if (UseFileSystem ==false)
{
LogManager.Log(LogLevel.Critical, "Priya.InfoList.DataSource-HaveDb", "Have Db is false for " + DbName + "[" + message + "]");
}
else
{
LogManager.Log(LogLevel.Critical, "Priya.InfoList.DataSource-HaveDb", "Have Db is false for " + DbName + ". Use FileSystem is true");
}
}
return _db;
}
