public void Delete(int id) { MinimalDataContext minimalDataContext = new MinimalDataContext(connectionString); UserDataModel model = new UserDataModel(); model.Id = id; minimalDataContext.Delete(model); }
public UserDataModel Get(int id) { MinimalDataContext minimalDataContext = new MinimalDataContext(connectionString); UserDataModel model = new UserDataModel(); model.Id = id; var result = minimalDataContext.GetUserData(model); return(result); }
public void TestUpdateModel() { MinimalDataContext dataContext = new MinimalDataContext(connectionString); UserDataModel dataModel = new UserDataModel(); dataModel.Id = 1; dataModel.Name = "Marco"; dataModel.InsertDatetime = DateTime.Now; dataModel.Value = 200; dataContext.Update(dataModel); Assert.True(true); }
public void TestInsertModel() { MinimalDataContext dataContext = new MinimalDataContext(connectionString); UserDataModel dataModel = new UserDataModel(); dataModel.Id = 1; dataModel.Name = "Lorenzo"; dataModel.InsertDatetime = DateTime.Now; dataModel.Value = 100; dataContext.Insert(dataModel); Assert.True(true); }
static void Main(string[] args) { if (File.Exists("export.csv")) { File.Delete("export.csv"); } string connectionString = "Data Source=localhost;Database=tutorial_db;userid=xxxx;password=xxxxx"; MinimalDataContext dataContext = new MinimalDataContext(connectionString); var mydataList = dataContext.GetUserData(); CSVSerializer serializer = new CSVSerializer(); using (StreamWriter file = new StreamWriter("export.csv")) { foreach (var item in mydataList) { file.WriteLine(serializer.Serialize(item)); } } dataContext.DeleteAll(); using (StreamReader reader = new StreamReader("export.csv")) { string line; while ((line = reader.ReadLine()) != null) { var model = serializer.Deserialize(line); dataContext.Insert(model); } } }
public void Put(int id, [FromBody] UserDataModel value) { MinimalDataContext minimalDataContext = new MinimalDataContext(connectionString); minimalDataContext.Update(value); }
public void Post([FromBody] UserDataModel value) { MinimalDataContext minimalDataContext = new MinimalDataContext(connectionString); minimalDataContext.Insert(value); }
public IEnumerable <UserDataModel> Get() { MinimalDataContext minimalDataContext = new MinimalDataContext(connectionString); return(minimalDataContext.GetUserData()); }