Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 3 years ago. Improve this question Overview One of the things I’ve … Read more
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
What is the best way to get the Max value from a LINQ query that may return no rows? If I just do Dim x = (From y In context.MyTable _ Where y.MyField = value _ Select y.MyCounter).Max I get an error when the query returns no rows. I could do Dim x = (From … Read more
How do I do this Select top 10 Foo from MyTable in Linq to SQL? 13 Answers 13
I have seen lots of examples in LINQ to SQL examples on how to do a join in query syntax but I am wondering how to do it with method syntax? For example how might I do the following var result = from sc in enumerableOfSomeClass join soc in enumerableOfSomeOtherClass on sc.Property1 equals soc.Property2 select … Read more
Using the simple example below, what is the best way to return results from multiple tables using Linq to SQL? Say I have two tables: Dogs: Name, Age, BreedId Breeds: BreedId, BreedName I want to return all dogs with their BreedName. I should get all dogs using something like this with no problems: public IQueryable<Dog> … Read more
Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself. I want to compare 12/3/89 12:43:34 and 12/3/89 11:22:12 … Read more
I want to add some rows to a database using Linq to SQL, but I want to make a “custom check” before adding the rows to know if I must add, replace or ignore the incomming rows. I’d like to keep the trafic between the client and the DB server as low as possible and … Read more
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 3 years ago. Improve this question How would you rate each of them in terms of: Performance Speed of development Neat, intuitive, maintainable code Flexibility … Read more
