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());
}
