public static List <T> GetAllFromEntity <T>() where T : class
{
using (var db = new ewkDB())
{
return(db.GetTable <T>().ToList());
}
}
public static void DeleteEntity <T>(T entity) where T : class
{
using (var db = new ewkDB())
{
db.Delete <T>(entity);
}
}
public static void InsertEntityBySP <T>(string email) where T : class
{
using (var db = new ewkDB())
{
db.ExecuteProc("insert_account", DataParameter.VarChar("email", email));
}
}
public static object InsertEntity <T>(T entity) where T : class
{
using (var db = new ewkDB())
{
return(db.InsertWithIdentity <T>(entity));
}
}
public void IsEqualValue([Values(ProviderName.PostgreSQL)] string configString)
{
using (var db = new ewkDB(configString))
{
var result = from a in db.accounts where a.email.Equals("*****@*****.**") select a;
Console.WriteLine("result = {0}", result.ToList().Count);
}
}
public void TruncateAccount()
{
using (var db = new ewkDB(ProviderName.PostgreSQL))
{
db.Execute("TRUNCATE account CASCADE");
//GenericCRUD.DeleteEntity<account>(db.accounts);
}
}
public static bool IsEqualEmail(string email)
{
using (var db = new ewkDB())
{
var result = from account_ in db.accounts where account_.email.Equals(email) select account_;
return(result.ToList().Count > 0);
}
}
//public static List<T> GetEntitiesByParameters<T>(Func<T, bool> where) where T : class
//{
// using (var db = new ewkDB())
// {
// return db.GetTable<T>().Where<T>(where).Where<T>(GetLogicExclusion<T>()).ToList);
// }
//}
/// <summary>
///
/// </summary>
/// <typeparam name="T">linqToDb Table mapped</typeparam>
/// <param name="pk"> Have to be of the same type of primary key atribute of T table mapped</param>
/// <returns>T linqToDb mapped class</returns>
public static T GetEntityByPK <T>(object pk) where T : class
{
using (var db = new ewkDB())
{
var pkName = typeof(T).GetProperties().Where(prop => prop.GetCustomAttributes(typeof(LinqToDB.Mapping.PrimaryKeyAttribute), false).Count() > 0).First();
var expression = SimpleComparison <T>(pkName.Name, pk);
return(db.GetTable <T>().Where <T>(expression).FirstOrDefault());
}
}
public void InsertAccountBySP([Values(ProviderName.PostgreSQL)] string configString)
{
int id_count = 0;
string template_email = "test_{0}[email protected]";
using (var db = new ewkDB(configString))
{
for (int i = id_count; i < 200000; ++i)
{
db.ExecuteProc("insert_account", DataParameter.VarChar("email", string.Format(template_email, i)));
}
}
}
/// <summary>
/// Excelent to use to get entities by FK
/// </summary>
/// <typeparam name="T">Entity To Filter From DB Mapped</typeparam>
/// <typeparam name="D">Type of property to filter using Equals Comparer</typeparam>
/// <param name="propertyName">Name of property</param>
/// <param name="valueToFilter">Value to filter query</param>
/// <returns>List of T</returns>
public static List <T> GetAllEntititiesByPropertyValue <T, D>(string propertyName, D valueToFilter)
where T : class
{
if (string.IsNullOrWhiteSpace(propertyName))
{
return(GetAllFromEntity <T>());
}
var expression = SimpleComparison <T, D>(propertyName, valueToFilter);
using (var db = new ewkDB())
{
var data = db.GetTable <T>().Where <T>(expression).ToList();
return(data);
}
}
void TestLinqToDbWithAccount()
{
using (var db = new ewkDB())
{
//var id = db.InsertWithIdentity<Account>(new Account() { EMail = "*****@*****.**", FirstSignedDate = DateTime.Now });
//Console.WriteLine("id = {0}", id);
db.ExecuteProc("test_insert", DataParameter.VarChar("email", "*****@*****.**"));
List <account> list;// = TestLinq2Db.All();
var query = from p in db.accounts
//where p.ProductID > 25
select p;
list = query.ToList();
foreach (account p in list)
{
Console.WriteLine(p.email);
}
}
}