public static List<Route> GetRoutesFromUserId(int userId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from c in data.ActiveRouteDataProviders
where c.user_id == userId
select
new Route
{
GMTOffset = c.gmt_offset,
Distance = c.distance,
EndLatitude = c.end_latitude,
EndLongitude = c.end_longitude,
EndTime = c.end_time,
Mode = c.mode,
Points = c.points,
StartLatitude = c.start_latitude,
StartLongitude = c.start_longitude,
StartTime = c.start_time,
Steps = c.steps,
Type = c.type,
UserId = c.user_id
}).ToList();
}
}