linq tag

9 questions


1 answers
76 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...

1 years ago

1 answers
48 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...

1 years ago

1 answers
52 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...

1 years ago

5 answers
89 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...

1 years ago

5 answers
91 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...

1 years ago

1 answers
71 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...

1 years ago

2 answers
98 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...

1 years ago

2 answers
78 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
78 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...

1 years ago

© 2024 OneMinuteCode. All rights reserved.