// DELETE api/values/5 public dynamic Delete(int id) { DemoDb db = new DemoDb(); int result = db.Database.ExecuteSqlCommand("delete from tasks where id=" + id); return(Json(new { type = result, mess = "" })); }
// POST api/values public dynamic Post(Task model) { DemoDb db = new DemoDb(); db.Tasks.Add(model); db.SaveChanges(); return(Json(new { type = model.id, mess = "" })); }
// GET api/values public dynamic GetList() { DemoDb db = new DemoDb(); dynamic result = new ExpandoObject(); result.expertInfoEducation = db.Tasks.ToList(); return(result); }
void createdemo() { try { ViewBase.ApplicationObject = _applicationObject; DemoDb.Create(); } catch (Exception e1) { ViewBase.ApplicationObject.StatusBar.Clear(); LoggingHelper.HandleException(e1); } }
// GET api/values/5 public dynamic Get(int id) { DemoDb db = new DemoDb(); return(db.Tasks.FirstOrDefault(c => c.id == id)); }
static void Main(string[] args) { DemoDb db = new DemoDb(); db.Execute(@"CREATE TABLE dictionary( id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(256), description TEXT ) ;"); Console.WriteLine("Table created"); Console.WriteLine(); int affectedRows = db.Execute("INSERT INTO dictionary(title, description) VALUES(@0, @1)", "Java", @"Java is a programming language originally developed by James Gosling at Sun Microsystems (which is now a subsidiary of Oracle Corporation) and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities."); Console.WriteLine("Inserted {0} rows", affectedRows); affectedRows = db.Execute("INSERT INTO dictionary(title, description) VALUES(@0, @1)", "Ruby", @"A dynamic, open source programming language with a focus on simplicity and productivity."); Console.WriteLine("Inserted {0} rows", affectedRows); affectedRows = db.Execute("INSERT INTO dictionary(title, description) VALUES(@0, @1)", "C#", @"C# (pronounced 'see sharp') is a multi-paradigm programming language encompassing imperative, declarative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines. It was developed by Microsoft within the .NET initiative and later approved as a standard by Ecma (ECMA-334) and ISO (ISO/IEC 23270). "); Console.WriteLine("Inserted {0} rows", affectedRows); Console.WriteLine(); Console.WriteLine("Dictionary:"); Console.WriteLine("Id\tTitle\tDescription"); var res = db.Query("SELECT * FROM dictionary"); foreach (var r in res) { Console.WriteLine("{0}\t{1}\t...", r.id, r.title); } var c = db.Query("SELECT COUNT(*) AS Count FROM dictionary"); Console.WriteLine("Count of record is {0}", c[0].Count); Console.WriteLine(); Console.WriteLine("Finding Ruby Programming language"); Console.WriteLine("Id\tTitle\tDescription"); var ruby = db.Query("SELECT * FROM dictionary WHERE title = @0", "Ruby"); foreach (var r in ruby) { Console.WriteLine("{0}\t{1}\t...", r.id, r.title); } Console.ReadKey(); }