Language INtegrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.
1
vote
1answer
23 views
Optimize Linq search query with multiple if statements
I have a search function in my class which checks various class property values for null or certain values and queries the database based on those properties. This how my function looks like now:
...
1
vote
1answer
87 views
Getting price for one firm by week
I've a lot of data whit prices of a product from different firms by week. I've a class named WeekPrice witch contains a list of ...
0
votes
1answer
49 views
Skip by Id on large list
This is in ASP.NET MVC, but that shouldn't make a difference. I have a large number of rows in my database for Songs.
...
3
votes
2answers
153 views
Operator-based switch for a database query filter
I am currently working on a method, that can search based on a value and an operator.
Currently I check which operator was supplied to the the method in a switch, and do operations accordingly to it.
...
0
votes
1answer
18 views
passing model to _layout.cshtml
I have login page that looks like
It has a ViewModelBase & a ViewModel as
...
5
votes
3answers
158 views
OnStartApplicationsCommand function
The foreach loop seems ridiculously lengthy and I am trying to get rid of it altogether is possible. But there are a lot of things happening in there which I need ...
2
votes
1answer
50 views
0
votes
0answers
43 views
Distinct List of attribute values from XML, using a pre-defined set of attribute names
I have an XML stream that looks like the following (attribute and node quantity , and node depth reduced for demonstration purposes.)
...
1
vote
1answer
68 views
LINQ query for a user's submitted time-off requests
What is a better way to create this select statement? I tried to just select 'u' and 'us', but the object properties were not accessible when I did this.
...
3
votes
1answer
437 views
Using Linq instead of multiple foreach loops
A project I'm working on often has lists within lists within lists etc. The original author often uses complicated linq expressions, but when adapting them I mostly get hopelessly bogged down and ...
10
votes
3answers
205 views
Tracking Entity Changes (not EF)
So, I kept refactoring my Sage300 API wrapper - I wanted the client code to feel just like using Entity Framework - this is the closest I got to it:
...
3
votes
1answer
48 views
Building expression tree with multiple OrElse
I am creating a way for users to filter results based on start and end values. An example of this would be:
...
5
votes
1answer
78 views
Paginating blog posts from SQL server using nested LINQ statements
I made an ASP.NET MVC application using Entity Framework for code-first migrations to the SQL Server database. I also use Unity (DI/IoC) for managing the services and repositories.
I made an overview ...
0
votes
1answer
87 views
Method or helper function to return objects from EntityFramework with Linq [closed]
The following code reads from Microsoft EntityFramework 6.0 domain model and returns the single view_patient object. The view_patient object is defined in the backend database and uploaded to the ...
1
vote
1answer
137 views
Converting from strings to byte arrays with LINQ in C#
I'm taking in a string of input from the command line, and when prefixed by 0o or 8# interpreting it as an octal string. I'd ...
7
votes
2answers
133 views
Struct implementation of immutable Maybe<T> monad
I have developed the following implementation of an immutable struct Maybe<T> monad for use in my game project; as an ...
3
votes
1answer
55 views
Convert reader to list of class
Class Student
{
Int studentId,
List<ClassB> Books,
Bool IsPassed
}
Class Book
{
Int bookId,
List<int> pages
}
I am creating a list ...
1
vote
1answer
41 views
Eager Loading Deeply into a Model with a Collection Property Whose Type is Inherited
Visual Studio generated this great route for me, where I can load an entity:
...
0
votes
0answers
31 views
Get a list of inherited classes using Linq to Entities
I have inherited classes in Entity Framework. I have a base class (ArticleBase) and two classes Review and Article which inherit from it. I am returning a list of the latest Articles and Reviews ...
2
votes
2answers
57 views
How to find contradiction in order of items in multiple sequences
Suppose you have several sequences:
A: 1 2 3 4 5
B: 2 4 5
C: 2 1 3 4 5
D: 3 2
Here, some pairs of list contradicts each other, because they ...
8
votes
1answer
98 views
Linq-to-Sage Implementation
Following-up on my last question where I wrapped the Sage API with a familiar IRepository interface, I decided to push the abstraction a step further, and... ...
2
votes
1answer
61 views
LINQ statements that aggregate sums from a List of objects
I'm packaging data for use in a JavaScript charting library that expects a somewhat odd structure of data in which there is an array of labels and an array of ...
0
votes
0answers
51 views
Optimizing LINQ with SelectMany aggregation
I have the following query which appears to be a bottleneck in my app:
...
2
votes
2answers
83 views
Medical appointment book history
This code correctly returns a View_appointment. Is there a better way to
accomplish this with using left joins and unions? I'm trying to learn Linq a little bit ...
0
votes
1answer
53 views
Pull back records that include child records
I am trying to pull back records that include child records for the View I'm putting together. Right now I have a working Linq statement, but it's big, and I think I could make it cleaner.
...
5
votes
1answer
67 views
Categorize episode-file names - Follow up
This is a follow up to this question.
I have implemented changes to the code as they were suggested in the previous question and have made a few changes of my own.
But it has been mentioned that the ...
2
votes
0answers
53 views
Convex envelope algorithm of random set of points
This is my "naive" implementation of a convex hull algorithm. By naive I mean that I am not using any of the advanced algorithms that exist to solve this problem.
...
11
votes
3answers
794 views
Give me thy name, I'll invoke thee
This generic function invokes a property of a given object by name:
...
5
votes
1answer
57 views
Using LINQ to output SQL data from two tables into XML
I am very new to this. Hope someone could help me suggest how to improve the code.
I have two tables where I need to get the SQL data and output it into XML format. I am using LINQ method. Below how ...
6
votes
1answer
156 views
5
votes
2answers
136 views
Query Builder pattern with use of FluentApi
Recently, I've come up with an idea of building a custom query builder combine with FluentApi.
Expected usage:
...
-4
votes
2answers
104 views
3
votes
2answers
313 views
0
votes
2answers
43 views
Control DataTable to CSV toString() formatting
Following a question I asked and the advice on SO I implemented the following solution. Are there any downsides to such a solution? Is there a better way to make it changeable when I need to control ...
9
votes
2answers
370 views
Finding the busiest time-frame in a parking lot
The text file containing cars' arrival and departure time will upload stuff from the parking lot.
Text will be like this:
...
0
votes
1answer
92 views
2
votes
1answer
92 views
Simplifying a LINQ expression that finds the largest date smaller than another date
I have a LINQ 2 SQL query that needs to run a subquery in the where clause. The subquery just returns the largest date (from a date column) that is less than or equal to another date (an input to the ...
3
votes
3answers
136 views
Enumerate list with filter criteria
Given the following CreditCard object, how would you get a count of unexpired credit cards? What are the pros/cons of using each method? Or is there a ...
5
votes
3answers
375 views
Sorting a list based on date and time
I have a class that is used to basically store samples from data being read from a system. Within that class is a property that I use to store the date and time of that sample:
...
8
votes
3answers
662 views
LINQ queries improvement - repetition of query
I have a DAL class full of LINQ queries which I would like to improve as I found that I'm repeating myself couple of times.
As you can see the part below is repeated couple of times and I was ...
-4
votes
1answer
38 views
Linq to get records of various status [closed]
I converted an Stored Procedure into a Linq Query, but it do not get any records.
Stored Procedure:
...
7
votes
3answers
189 views
Fetching a set of event IDs from a database based on a set of company IDs
The following code fetches a set of company IDs from a database if there are any events associated with a company that has a missing property. Because the set of company IDs is embedded into the SQL ...
3
votes
2answers
238 views
Find a serial port device through WMI (windows management instrumentation)
The idea here is to be able to find a USB serial port device connected during runtime, thus not knowing its port number, and use it in the application to retrieve information from the device.
...
3
votes
4answers
183 views
IEnumerable Extensions Linq AllOrDefault() Each()
I recently decided to try and write my own implementation of Linq, which then lead me on to trying to solve some of the problems we have in our code base at work. Our code is littered with the ...
2
votes
2answers
188 views
Linq-to-Sql Contains an int? inside a list of int
Curious if there is a better way to write a repository method that receives argument List<int> and checks if the database ...
2
votes
2answers
113 views
Checking for violation of primary key in a DataTable
I coded this function to check for a violation of a primary key in a DataTable. The main idea is to retrieve a list of every row that the same value of the column ...
2
votes
1answer
79 views
Counting email addresses with different status
I want to count email addresses with different status. I use ASP.NET MVC and this query is supposed to run every 5 minutes on these tables, which every table is on different .ndf files. About 5 ...
4
votes
1answer
137 views
12-week staffing forecast LINQ query
I have a LINQ query that I am having trouble optimizing and takes about 5.5 seconds to run. I am using a view called StaffingResourceData and a table called StaffingForecasts.
Each StaffingResource ...
2
votes
2answers
66 views
Grouping over a list of dictionaries
I am consuming data from an API that reads from a SharePoint list. The API is basically this:
...
-1
votes
3answers
67 views
Checking string length limitation and add items to it in a shorter way with Linq
This method has three parameters. If the extension is not null, for each item in list try to add extension to main text in a way that length of result doesn't exceed 20.
I wrote this code, but I ...
