linq tag

9 questions


1 answers
98 views
0
I want to convert ROW_NUMBER()OVER(PARTION BY) to LINQ.

Thank you for always taking care of me.I want to get the same results as the SQL below on LINQ, but I'm struggling because I can't meet my expectations.I tried to create it based on the information he...

2 years ago

1 answers
61 views
0
Understanding Linqcsv Connections for C#

I have a question about Linq of C#.Based on the code of the ms site, I wrote a code that connects the two csv files with inner join and outputs them. In the code, the output is from field 0 to field 4...

2 years ago

1 answers
66 views
0
Understanding Linqcsv Connections for C#

I have a question about Linq of C#.Based on the code of the ms site, I wrote a code that connects the two csv files with inner join and outputs them. In the code, the output is from field 0 to field 4...

2 years ago

5 answers
107 views
0
I want to get the top X scores on LINQ and rank them.

I'm trying to achieve the common Top X Points in LINQ.class member { public string name {get;set;} public int point {get;set;}}An instance array similar to the one shown in var SelectedMembers = AllMe...

2 years ago

5 answers
117 views
0
I want to get the top X scores on LINQ and rank them.

I'm trying to achieve the common Top X Points in LINQ.class member { public string name {get;set;} public int point {get;set;}}An instance array similar to the one shown in var SelectedMembers = AllMe...

2 years ago

1 answers
89 views
0
Understanding DataTable and linq

Thank you for taking care of me.string cmdQuery=SELECT* FROM TableA; using(DataTableTableA=newDataTable()) using(OleDbCommand cmd=newOleDbCommand(cmdQuery,conn)) using(OleDbDataAdapter=newOleDbData...

2 years ago

2 answers
123 views
0
I want to use LINQ to get the maximum value of properties for a class in a dictionary within a class.

I'm always studying.I'd like to borrow your advice today.Let me ask you a question.public class TestResult{ public string Kamoku; public int Tensu;}public class Grade { public int Rank; public List &l...

2 years ago

2 answers
94 views
0
If you save a Decimal value to SQLServer, it will only save up to two decimal places.

EntityFramework Version=6.0.0.0.Net Framework targetFramework=4.6.1SQL Server Express 13.0.4001.0In the table on SQL Server, there is a column created with Decimal (12,3) and Decimal (18,3) that is be...


1 answers
100 views
0
Please teach me about SQL.

Thank you for taking care of me.I would like to get data with the same ID, date, and serial number, code 1234 and 1235.tableA ID Date Serial Number  Code 120060223 1 1234 120060223 1235 120060415 111...

2 years ago

© 2024 OneMinuteCode. All rights reserved.