public static Order GetById(Guid orderId) { var query = SqlQueryGeneration.GetOrderById(orderId); var orders = _sqlManager.GetOrder(query); FillObjectData(ref orders); return(orders.FirstOrDefault()); }