public void Update <T>(CatalogHolder <T> obj) where T : CatalogObjectBase { var sql = "UPDATE catalog SET name = @name, content = @content WHERE id = @id"; var catalogType = CatalogObjectExtensions.GetCatalogTypeFromAttribute <T>(); var json = JsonConvert.SerializeObject(obj.Content); var parameters = new { id = obj.Id.ToString(), name = obj.Name, catalogType, content = json }; _provider.ExecuteSqlite(sql, parameters); }
public void Add <T>(CatalogHolder <T> obj) where T : CatalogObjectBase { var sql = "INSERT INTO catalog (id, name, catalogType, content) VALUES (@id, @name, @catalogType, @content)"; var catalogType = CatalogObjectExtensions.GetCatalogTypeFromAttribute <T>(); var json = JsonConvert.SerializeObject(obj.Content); var parameters = new { id = obj.Id.ToString(), name = obj.Name, catalogType, content = json }; _provider.ExecuteSqlite(sql, parameters); }