Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.
1
vote
3answers
28 views
Cant get list from received XML file
This is xml that I receive:
<?xml version="1.0" encoding="UTF-8"?>
<mdpr:Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mdpr="http://...">
<mdpr:contactList>
...
1
vote
1answer
35 views
Convert List of object into another List of object
i have a list as
class Vachel
{
int id{get;set;}
int vachelid {get;set;}
string title {get;set;}
}
List of Vachel
as
id vachelid title
1 2 bus
1 3 truck
2 4 cycle
2 ...
0
votes
1answer
32 views
Field concatenation based on group in LINQ
I want concate a times field based on grouping of Userid and dates field using LINQ . i am using VS2010 C#(WPF).
i have a collection in below format.
and want result like
0
votes
0answers
14 views
Linq search - Display small part of searched text
I'm trying to implement text search with linq. I have a Messages table which is populated with emails data. I want to be able to search in Messages body. However emails bodies are very long and I will ...
0
votes
0answers
16 views
Complex SQL Query for a custom role provider
I have an ASP.NET custom role provider with the following tables.
[Role] RoleName( PK, nvarchar(100) );
[PermissionGroup] PermissionId( PK, int );PermissionGroupId( nvarchar(256) );
...
1
vote
2answers
59 views
C# - Reading XML file
I'm trying to read an XML file in order to integrate data into Windows Phone App.
I followed some other topics but I cannot get it to work (I feel I'm almost at the point but still missing ...
0
votes
2answers
40 views
Produce List with intent items from row text
I have some row text. I want from this text to create Events and intent activities, put them on lists and then import them on a db. Let me be more specific. Let’s assume that I have the following ...
1
vote
0answers
86 views
Linq update with an Ilist
I would like to update my database datas and I have the following 2 "lists" of element :
Linq Query returning me an IQueryable<VM_CategoryLabel> from the database (that has to be updated)
...
2
votes
2answers
35 views
Convert linq statement to sql
I am deprecating a project from linq coding back to sql stored procedures. (My company refuses to upgrade our sql 2000 database.) I am stuck on this current code trying to convert it to sql. Can ...
0
votes
1answer
22 views
Generate True False boolean enumerable in LINQ
I believe it is a simple problem. I want to generate a LINQ enumerable to use in a selectmany function. This is what I want to do
var completeMonthsList = (from p in MonthList ...
-4
votes
2answers
51 views
Removing special characters from strings in a List
I have a
List<string> names = new List<string>{"asa","@!","~!@#$%^tryt","asas**)_+lk"};//just an example...will be populated at run time
List<string> unsupportedCharacters = new ...
5
votes
3answers
58 views
Will the result of a LINQ query always be guaranteed to be in the correct order?
Question: Will the result of a LINQ query always be guaranteed to be in the correct order?
Example:
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var lowNums =
from n in numbers
where n ...
3
votes
3answers
30 views
IEnumerable<T>.Count() vs List<T>.Count with Entity Framework
I am retrieving a list of items using Entity Framework and if there are some items retrieved I do something with them.
var items = db.MyTable.Where(t => t.Expiration < DateTime.Now).ToList();
...
0
votes
2answers
32 views
this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[Monet.Models.AgentTransmission]'
I have two tables in my SQL database, one for storing the agent (AgentTransmission) and the other logs the transmission history (TransmissionHistory) of the agent (there will only be one successful, ...
1
vote
1answer
31 views
Entity Framework with LINQ using CONTAINS in WHERE clause very slow with large integer list
I have a function that first queries a function in the database that returns a list of employees that a user is allowed to see. This run in a couple ms. Using this list I query the employee table to ...
