[DotNetDevelopment] Need help with LINQ "no supported translation to SQL" error

[comicrage]

Hi,

I am learning the generated LINQTOSQL entity class. Everything worked
until I added 2 datetime variables as folllowed. I passed the data
object from client to WCF and back to SQL Server. I wanted to add two
extra datetime parameters, which are not in the database table. The
idea is to perform a date range query agaisnt the timestamp
transaction datetime. When I added the start and end datetime, I get
a .StartDateTime has no supported translation to SQL error. How can I
fix this issue in the DataContent/Data model class to perform the
query?

Thanks

        private System.DateTime _StartDateTime;

        private System.DateTime _EndDateTime;

        public System.DateTime StartDateTime
        {
            get { return this._StartDateTime; }
            set
            {
                if ((value != null && this._StartDateTime != value))
                {
                    _StartDateTime = value;
                }
            }
        }

        public System.DateTime EndDateTime
        {
            get { return this._EndDateTime; }
            set
            {
                if ((value != null && this._EndDateTime != value))
                {
                    _EndDateTime = value;
                }
            }
        }


-- 
Subscription settings: 
http://groups.google.com/group/dotnetdevelopment/subscribe?hl=en