Tagged Questions

1
vote
1answer
47 views

(More) efficient and elegant way to retrieve data from a dataset?

I have a DataSet with only two tables in it. The first table is a list of models (of products) with default parameters (settings), and the second table is a list of modules. A module is a product ...
7
votes
3answers
324 views

How to optimize this code to get a instant/better result instead of waiting at least 10 seconds every time?

I have the following code that unfortunately is really slow: private void FilterSessionByDate() { SessionsFilteredByDate = ...
4
votes
2answers
220 views

LINQ Query performance - how to go about improving THIS query?

I have written a module in my application that makes extensive use of Dynamic LINQ to produce linq/sql queries based on user interface selection. Currently, the linq-sql translation is resulting in ...
0
votes
2answers
4k views

Inserting Data in The Database using LINQ TO SQL

Can this Code be any shorter? because it seems it is very long with just simple insertion of data using LINQ TO SQL public void addPatientInformation() { using(DbClassesDataContext ...
2
votes
2answers
331 views

Can This LINQ to SQL query be any cleaner?

I am working on a log in form, basically what my code does is search for a user name, then retrieves the hashed password that is related to that account.then converts that string hashed password.then ...
1
vote
3answers
422 views

Any improvement on this ridiculously inefficient LINQ query?

I have following (extremely simplified) database structure: table: Competitions Id: string, unique table: Persons Id: string, unique Gender: string table: Results CompetitionId: string, ...