C#

I want to compare to see if sql date > minimum date (1/1/1753) and sql date < current today's date. Can you tell me how to write this comparision?

DateTime minDate = DateTime.ParseExact("1753/01/01, "yyyy/MM/dd", CultureInfo.InvariantCulture,DateTimeStyles.None);
var result = (from p in ctx.SomeTable
where p.MyDate > minDate && p.MyDate < DateTime.Now
select p).ToList();

classy_dog wrote:

1. The code you have above will let me compare a C# date to a sql server 2008 r2
date,correct? Is there any kind of a conversion needed?

classy_dog wrote:

2.Your code listed above will only compare by dates and will not include the
time correct?

classy_dog wrote:

I am using a linq to sql statement to compare a C# datetime field

using System;
using System.Xml.Serialization;
using System.IO;
using System.Xml;
using System.Text;

namespace Test
{
    [Serializable]
    [XmlRoot("RootElement")]
    public class RootElement
    {
        [XmlElement]
        public int Id { get; set; }
        public string Name { get; set; }
        public Address Address_1 { get; set; }
        public Address Address_2 { get; set; }
    }

    public class Address
    {
        [XmlElement]
        public string Number {get; set;}
        public string Street { get; set; }
        public string Town { get; set; }
    }

    public class Test2
    {
        Address address_1 = new Address()
        {
            Number = "123",
            Street = "My Road",
            Town = "My Home Town"
        };

        Address address_2 = new Address()
        {
            Number = "PO BOX 456",
            Street = "My Street",
            Town = "My Birth Town"
        };

        public void setXmlValues()
        {
            RootElement testOut = new RootElement {
                                                    Id = 1,
                                                    Name = "Customer Name",
                                                    Address_1 = address_1,
                                                    Address_2 = address_2
                                                    };

            xml_serialise(testOut);

            RootElement testIn = xml_deserialise();
            int id = testIn.Id;
            string Name = testIn.Name;
            string myBirthTown = testIn.Address_2.Town;

        }


        private void xml_serialise(RootElement test)
        {
            XmlSerializer ser = new XmlSerializer(typeof(RootElement));


            using (TextWriter writer = new StreamWriter("test.xml"))
            {
                ser.Serialize(writer, test);
            }
        }

        private RootElement xml_deserialise()
        {
            XmlSerializer ser = new XmlSerializer(typeof(RootElement));

            RootElement test;

            using (TextReader writer = new StreamReader("test.xml"))
            {
                test = (RootElement)ser.Deserialize(writer);
            }

            return test;
        }
    }
}

// for (int i = 0; i < rows.Length; i++)
// {
      dt.Rows.Add(rows);      // only insert it once
// }//end for