All Questions
Tagged with recursive-query c#
28 questions
0
votes
4
answers
350
views
how to write stored recursive procedure in order to get hierarchical element
hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc..
I want to get all the list of the attributs(even the attributs of the parents)
...
0
votes
3
answers
764
views
How to get the list of employees and their reporting level recursively using LINQ
I have a table for list of employees with their supervisors.
| UserID | SupervisorUserId |
|--------|------------------|
| 10 | null |
| 1 | 10 |
| 2 | 1 ...
1
vote
2
answers
497
views
Recursive query takes too much time to load data in C#
*I have written a recursive query to get unlimited menu layer. The query works fine providing the exact results but it takes too much time to load. It takes probably 10 to 15 seconds. Please help me ...
1
vote
2
answers
3k
views
C# List<(string,string)> matching and replacing values
I'll try to explain this as simple as I can, it's quite a specific issue. I've been using F# for a while now and this may be causing me to get confused. What i'm trying to do is essentially (or close ...
- 13
2
votes
1
answer
686
views
SQLite recursive query to get first branch of tree
I'm building a Xamarin.Forms application. I have a table in my SQLite database that holds hierarchical data in a tree shape. Let's call it TreeNode:
public class TreeNode
{
[PrimaryKey]
...
- 325
0
votes
2
answers
2k
views
How to write a recursive query with 2 tables in SQL Server
I have a table with the following structure.
Table name: Table0
The structure is as below
Select process from Table0 where Name like '%Aswini%'
Process
-------
112
778
756
All these process must go ...
- 51
1
vote
1
answer
185
views
Recursive query in EntityFramework throws NotSupportedException
I want to build a recursive query in EntityFramework 6.2.0 to get an employee and all his "direct" (one level) and all other subordinates down all the hierarchy.
My point was to use List<...
- 2,944
0
votes
2
answers
533
views
Check property value in nested list with unknown levels
I have a nested menu - here a simplified class:
public class NestedNode
{
public string Url { get; set; }
public List<NestedNode> Children { get; set; }
}
Given that I have a recursive ...
- 2,901
2
votes
2
answers
113
views
Recursive lookup needed. DB vs. C# GUI
I currently have a program in which I want to list 'support tickets' in a grid.
The tickets are coming from a SQL DB out of a ticketing system.
A ticket has an activity, example:
I have a fully ...
- 577
0
votes
2
answers
65
views
Need to generate a view from recursive table
I am stuck at this point if any one can help:
i have table looks like below
Please note: that there can be n number of levels, but if you add item in a level then you can not create sub levels.
FROM ...
2
votes
1
answer
370
views
Optimization of Memory while reading a large excel sheet
I do have an excel file of which i developed a way of reading all the contents in sheet 1 and populates it into a listview, basically the sheet has data in cells A-D. but the number is 120,000. when i ...
- 85
1
vote
2
answers
50
views
Return from loop but the execution of loop not effects?
Is is possible in php when return some value from loop and execution of loop still continues from next index (like GetEnumerator() in C# and the use MoveNext())
problem-
$arr=[0,1,5,9,5];
$i=count($...
0
votes
1
answer
597
views
How to get Twitter statuses with replies using TweetSharp
I'm trying to get all Tweets tweeted by me with replies (if any).
I'm using TweetSharp and I'm able to get my own tweets but couldn't figure out how to get the replies as well in the same request/...
- 131
0
votes
2
answers
2k
views
ASP MVC 5 C# Recursive Trees To Group and Indent A DropDownList
I have a Model called Category which has a recursive (parent child) relationship as follows:
public class Category: ITreeNode<Category>
{
public byte Id { get; set; }
public ...
- 10.1k
0
votes
1
answer
80
views
Recursive statement in MySQL on two tables
I now sit for the first time in a MySQL database and need to create a "tree traversal" query.
I have 2 tables:
Team:
--------------------------------
|INT id|VARCHAR name|INT parent|
---------------...
- 118