ASP.NET

Quote:

C#

string yesterday = DateTime.Today.AddDays(-1).ToShortDateString();

string yesterday = db.database_BWICs.Find(d => d.UploadDate == yesterday);

db.database_WICs.Find(d => d.UploadDate == yesterday

namespace Wic_T1
{
    using System;
    using System.Collections.Generic;
    using System.Runtime.Serialization;

     [DataContract]
    public partial class database_WICs
    {
        [DataMember]
        public int ID { get; set; }
        [DataMember]
        public string Name { get; set; }
        public Nullable<System.DateTime> SaleDateTime { get; set; }
        public string Region { get; set; }
        [DataMember]
        public string CUSIP { get; set; }
        [DataMember]
        public string Size__m_ { get; set; }
        public string OriginalRating { get; set; }
        public Nullable<System.DateTime> MaturityDate { get; set; }
        public string Manager { get; set; }
        [DataMember]
        public string priceTalk { get; set; }
        [DataMember]
        public string Cover { get; set; }
        public Nullable<System.DateTime> LastUpdated { get; set; }
        [DataMember]
        public Nullable<System.DateTime> UploadDate { get; set; }
        [DataMember]
        public string Type { get; set; }
        [DataMember]
        public string ISINs { get; set; }
        [DataMember]
        public Nullable<float> Decimal_price { get; set; }
        public string CMBS_spread { get; set; }
        public Nullable<float> CMBS_decimal { get; set; }
        [DataMember]
        public string Current_size { get; set; }
    }
}

<pre lang="c#">public IEnumerable<database_BWICs> GetDate()
        {
            DateTime yesterday = DateTime.Today.AddDays(-1);

            var data = from c in db.database_BWICs
                       where c.UploadDate == yesterday
                       select c;
            return data.ToList();
        }