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

learn more… | top users | synonyms

0
votes
1answer
18 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
43 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
83 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. ...
1
vote
0answers
56 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
105 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
94 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
52 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
158 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
29 views

Passing model to _layout.cshtml

I have login page that looks like: It has a ViewModelBase and 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
57 views
0
votes
0answers
44 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
69 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
442 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
213 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
57 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
80 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
97 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
155 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
144 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
59 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
42 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
33 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
58 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
55 views

Optimizing LINQ with SelectMany aggregation

I have the following query which appears to be a bottleneck in my app: ...
2
votes
2answers
90 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
68 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
55 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
59 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
159 views

Joining datatables to create a new datatable

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

Remove from list value where date less than max date value

How can I improve this code? ...
3
votes
2answers
411 views
0
votes
2answers
50 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
378 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
102 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
138 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
502 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
665 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
326 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
191 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
256 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 ...