C#

Hi
I’ve a question regarding linq,
I’ve a DB contains main items (Product) and internal item(properties)

Class Product
{
    String name
List<properties> propList { get; set; }
}

Class properties
{
    String name
String value
}

I would like to know if it possible to create a query that apply on two or more categories on the same internal item at one time
Such as, if the product is "car" and if the car year is 2012 and color is "Red" I would like to get this record

List< Product > DB;

I know the syntax below is wrong, but this is the idea I wish to do
Enumerable< Product > itemQuery = from item in DB where item.name=="car"
                                            where
                                            (
                                                from prop in item.propList
                                                where (prop.name.Equals("Color") && prop.value == "Red") && (prop.name.Equals("Year") && prop.value == "2012")
                                                select field
                                             ).Any()
                                            select item;

using System;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.Collections.Generic;

namespace NSSWebServiceApplication
{
    [ServiceContract(Namespace = "")]
    [SilverlightFaultBehavior]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
    public class NSSService
    {
        [OperationContract]
        public List<Server_Log> GetAllServer_Logs()
        {
            // Add your operation implementation here
            using (NSSEntities entities = new NSSEntities())
            {
                var allServer_Logs = from x in entities.Server_Log
                                     select x;
                return allServer_Logs.ToList();
            }
        }

        // Add more operations here and mark them with [OperationContract]
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using Microsoft.Phone.Controls;
using NSSPhoneApp.NSSServiceReference;
using System.ServiceModel;

namespace NSSPhoneApp
{
    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            this.Loaded += new RoutedEventHandler(MainPage_Loaded);
        }

        void MainPage_Loaded(object sender, RoutedEventArgs e)
        {
            NSSServiceClient client = new NSSServiceClient();
            client.GetAllServer_LogsCompleted +=
                new EventHandler<GetAllServer_LogsCompletedEventArgs>(client_GetAllServer_LogsCompleted);
            client.GetAllServer_LogsAsync();
        }

        void client_GetAllServer_LogsCompleted(object sender, GetAllServer_LogsCompletedEventArgs e)
        {
            if (e.Error == null)
            {
                lst.ItemsSource = e.Result;
            }
        }
    }
}