Language INtegrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.

learn more… | top users | synonyms

3
votes
4answers
286 views

PermMissingElem- find the missing element in a given permutation in C#

I just encountered this question in codility but apparently this question has been asked in java already (here, here). Task description A zero-indexed array A consisting of \$N\$ different integers ...
5
votes
1answer
59 views

Merging trips to the same location with overlapping dates

I have a SQLite database that only contains the holidays for 1 user. I have a new Trip object (newTrip) that has a ...
3
votes
1answer
85 views

Retrieving collections from a database

I have two collections that I want to retrieve from the database and associate with each other. My solution works, however I know it isn't the most elegant one. Do you have any suggestions on how to ...
-1
votes
0answers
13 views

Linq to Xml - Update existing xml document [on hold]

Hie everyone. Im tring to update an existing xml document that is part and parcel of the application. The xml document contains instructions for the application. I have been searching how to save and ...
4
votes
1answer
299 views

Find the odd occurrences in an array

Recently, I came across this problem on Codility. I am aware there is a bit of similarity to Finding all integers in an array with odd occurrence and Most common occurrence of an int in an array . But ...
1
vote
1answer
62 views

Conditional aggregate whilst constructing array

I have the following snippet of code which gets a load of time intervals (every hour, every 2 hours etc), then groups the results for each of the intervals (e.g, the max value for each hour). This ...
0
votes
1answer
23 views

disable other defualt row- Entity framework

I have a table that name is Store , In Store Table , just one row can IsDefault=true at ...
0
votes
1answer
50 views

Map a hierarchy of nested DTO objects to a list of business objects [closed]

Consider I download my data into this data structures: ...
4
votes
2answers
91 views

Stitching Linq with if blocks

I recently learned about Linq's deferred execution and a little clearer understanding of IEnumerable. I came back to some code that I had written and decided to change with Linq extension methods. ...
3
votes
1answer
78 views

Rolling up Invoice Items Matching Certain Criteria

I have a listing of invoice line items that I need to apply some convoluted business logic to. We have another listing of items that I compare the invoice items to and if I find matches, I then need ...
0
votes
0answers
20 views

Find items in collection one that are the greatest value less than an item in collection two

This is hard to explain. I wanted to get all of the items in collection one (ints in the example below) that are the highest values that are lower than any of the items in collection two (otherInts). ...
4
votes
2answers
119 views

Customer search using LINQ followed by conditional filtering of results

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
96 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
56 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
164 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. ...
1
vote
1answer
40 views

Passing model to _layout.cshtml

I have login page that looks like: It has a ViewModelBase and a ViewModel as: ...
5
votes
3answers
159 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
61 views
0
votes
0answers
53 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
74 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
446 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
220 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
65 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
82 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
106 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
185 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
155 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
61 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
45 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: ...
1
vote
0answers
40 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
59 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
101 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
63 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
60 views

Optimizing LINQ with SelectMany aggregation

I have the following query which appears to be a bottleneck in my app: ...
2
votes
2answers
91 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
54 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
73 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
57 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
797 views

Give me thy name, I'll invoke thee

This generic function invokes a property of a given object by name: ...
5
votes
1answer
62 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
170 views

Joining datatables to create a new datatable

I am joining datatables to create a new datatable: ...
5
votes
2answers
203 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
108 views

Remove from list value where date less than max date value

How can I improve this code? ...
3
votes
2answers
508 views
0
votes
2answers
56 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
384 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

Select values from two collections

I have a model: ...
2
votes
1answer
114 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
139 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
661 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: ...