public static List <T> GetAllFromEntity <T>() where T : class { using (var db = new TravianBotDB()) { return(db.GetTable <T>().ToList()); } }
public static void DeleteEntity <T>(T entity) where T : class { using (var db = new TravianBotDB()) { db.Delete <T>(entity); } }
public static object InsertEntity <T>(T entity) where T : class { using (var db = new TravianBotDB()) { return(db.InsertWithIdentity <T>(entity)); } }
public static void UpdateEntity <T>(T entity) where T : class { using (var db = new TravianBotDB(cs)) { db.Update <T>(entity); } }
//public static List<T> GetEntitiesByParameters<T>(Func<T, bool> where) where T : class //{ // using (var db = new TravianBotDB()) // { // 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 TravianBotDB()) { 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()); } }
/// <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 TravianBotDB()) { var data = db.GetTable <T>().Where <T>(expression).ToList(); return(data); } }
// public ObservableCollection<Building> Buildings //{ // get // { // return buildings; // } // set // { // Set(() => Buildings, ref buildings, value); // } // } public Village(int villageId, string villageName, int x, int y, bool isActive = false, bool isCapital = false) { this.villageId = villageId; this.villageName = villageName; this.x = x; this.y = y; this.isActive = isActive; this.isCapital = isCapital; PropertyChanged += (s, e) => { Task.Run(() => { using (var db = new TravianBotDB()) { db.DB_Villages.Where(dV => dV.VillageId == VillageId) .Set(dV => dV.VillageName, VillageName) .Set(dV => dV.IsCapital, IsCapital).Update(); } }); }; //Buildings.CollectionChanged += Buildings_CollectionChanged; }