public TheTimeMachineEntity GetById(int id) { string sql = "select time_machine_id as TimeMachineId, time_machine_name as TimeMachineName from meta_time_machine where Id = ?"; using (var sqliteConn = connectionProvider.GetConnection()) { return(sqliteConn.QueryFirstOrDefault <TheTimeMachineEntity>(sql, new { Id = id })); } }
public void Create(MetaTimeMachineEntity entity) { string sql = "insert into meta_time_machine(time_machine_id, time_machine_name) values (@TimeMachineId, @TimeMachineName);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { TimeMachineId = entity.TimeMachineId, TimeMachineName = entity.TimeMachineName }); } }
public void Create(PlaceEntity entity) { string sql = "insert into place(name, longitude, latitude, time_machine_id) values (@Name, @Longitude, @Latitude, @TimeMachineId);"; using (var sqliteConn = connectionProvider.GetConnection()) { sqliteConn.Execute(sql, new { Name = entity.Name, Longitude = entity.Longitude, Latitude = entity.Latitude, TimeMachineId = entity.TimeMachineId }); } }