How to assign variable from different tables?
<p>I have a list of tables of Make and Models of Assets. I need to assign the Asset Make using AssetMakeString. Currently I have:</p>

<pre><code>    public class FuelLightTruckDataSource
    {
        public Model.Asset Asset { get; set; }
        public Employee Employee { get; set; }
        public FuelProductClass ProductClass { get; set; }
        public FuelVendor Vendor { get; set; }
        public FuelFillSource FillSource { get; set; }
        public AssetModel Model { get; set; }
        public AssetMake Make { get; set; }
        public string Source { get; set; }
        public string City { get; set; }
        public decimal Volume { get; set; }
        public decimal? Distance { get; set; }
        public decimal? Odomoter { get; set; }
        public decimal? DistanceVolume { get; set; }
        public float? ConsumptionRate { get; set; }
        public DateTime? Date { get; set; }
        public decimal? ConsumptionCalculated { get; set; }
        public decimal? DistanceCalculated { get; set; }

    public FuelLightTruckDataSource() { }

    public static List&lt;FuelLightTruckDataSource&gt; Get(DateTime from, DateTime to)
    {
        List&lt;FuelLightTruckDataSource&gt; data = new List&lt;FuelLightTruckDataSource&gt;();

        using (SystemContext ctx = new SystemContext())
        {

            List&lt;FuelLightTruckDataSource&gt; dataTransactions
                = ctx.FuelTransaction
                    .Where(tx =&gt; DbFunctions.TruncateTime(tx.DateTime) &gt;= from.Date &amp;&amp; DbFunctions.TruncateTime(tx.DateTime) &lt;= to.Date
                        //&amp;&amp; tx.AssetFilled.AssignedToEmployee.Manager
                        &amp;&amp; tx.AssetFilled.AssignedToEmployee != null
                        //&amp;
                        &amp;&amp; tx.AssetFilled.AssetType.Code == "L"
                        &amp;&amp; (tx.FuelProductType.FuelProductClass.Code == "GAS" || tx.FuelProductType.FuelProductClass.Code == "DSL"))
                    .GroupBy(tx =&gt; new { tx.AssetFilled, tx.DateTime, tx.FuelProductType.FuelProductClass, tx.FuelCard.FuelVendor, tx.City, tx.Volume, tx.Odometer}) //Added tx.volume to have individual transactions
                    .Select(g =&gt; new FuelLightTruckDataSource()
                    {
                        Asset = g.FirstOrDefault().AssetFilled,
                        Model = g.FirstOrDefault().AssetFilled.AssetModel,
                        Make = g.FirstOrDefault().AssetFilled.AssetModel.AssetMakeString,
                        Employee = g.FirstOrDefault().AssetFilled.AssignedToEmployee,
                        ProductClass = g.FirstOrDefault().FuelProductType.FuelProductClass,
                        Vendor = g.FirstOrDefault().FuelCard.FuelVendor,
                        FillSource = FuelFillSource.Transaction,
                        Source = "Fuel Station",
                        City = g.FirstOrDefault().City.ToUpper(),
                        Volume = g.FirstOrDefault().Volume,
                        Distance = g.FirstOrDefault().Odometer,
                        Date = g.FirstOrDefault().DateTime


                    })
                   // .OrderBy(tx =&gt; tx.Date)
                    .ToList();
</code></pre>

<p>My AssetModel class looks like this:</p>

<pre><code>{
    public class AssetModel
    {
        public int Id { get; set; }
        [Required]
        [MaxLength(100)]
        [Index("IX_AssetModel", 2, IsUnique = true)]
        public string Name { get; set; }
        [MaxLength(10)]
        [Index("IX_AssetModel", 3, IsUnique = true)]
        public string Year { get; set; }
        public string Description { get; set; }

        [Index("IX_AssetModel", 1, IsUnique = true)]
        public int? AssetMakeId { get; set; }

        public virtual AssetMake AssetMake { get; set; }
        public virtual List&lt;Asset&gt; Assets { get; set; }

    // **** Custom Properties ****

    public string AssetMakeName { get { return AssetMake.Name; } }
    public string AssetMakeString { get { return AssetMake.Name + " " + Name + (Year == null ? "" : " (" + Year + ")"); } }
}
</code></pre>

<p>}</p>

<p>Why am I getting "Error: Cannot implicitly convert type 'string' to 'PSI.ManagementSystem.Model.AssetMake'"?</p>