The error is with in the query string. Between keyword does not work well with string datatype.

I have tried similar problem using Genetic Algorithm and the results were astonishing. I think trying Genetic Algorithm may be wonderful for you too in speeding the search time.

To Insert new record: bool InsertNewProduct(Product p) { myDataContext dt= new myDataContext(); dt.Products.InsertOnSubmit(p); dt.SubmitCHanges(); return true; } To Insert new record: bool DeleteProduct(Product p) { myDataContext dt= new myDataContext(); dt.Products.DeleteOnSubmit(p); dt.SubmitCHanges(); return true }

You simply add first to the end of the Select logic listViewModel.EmailRecipients.AddRange( from r join p on r.PId equals p.PId join gp on p.PId equals gp.PId join hp on gp.HPId equals hp.HPId orderby p.LastName, p.FirstName select(new EmailRecipientViewModel { PId = p.PId, FirstName = p.FirstName, LastName = p.LastName, Email = "", }) ).First();

Try the following approach: public Product GetLastProduct(DataContext dt) { return dt.Products.Last(); } this code assumes two things: 1. your database has a Product table 2. You have created LINQ to SQL and you have dragged and Dropped the Product table on to the DataContext named dt

As to me you can try A genetic algorithm, that exploits the K-means principles for dividing objects in groups having high similarity. Those that lie with in the first, second or so would be selected as best alternatives for your search to fit to the case on hand.

Step one: Add new LINQ to SQL item from project Item in to your project and call it DXD (or any convinient name you like) Step two: drag and Drop the Employee TABLE from Server Explorer in your IDE to your LINQ to SQL DataContext object. Step Three: Add data source by selecting Object as data source Step Four: Go to your form and drag and drop Salary field from your data source object to your form Step Five: Set the Data Source of your EmployeeDatabinding object as EmployeeDatabinding.DataSource = DXD.Employee ... it is too long try another approach

Thank you for your replay .... however, I am looking different databases from the same provider

It is possible to have a single DataSet having multiple DataTables from multiple databases. If so can you just tell me how ?