No announcements
Found 15061 threads
-
0 VotesNumber of rows returned by a DataReader
User-408371289 posted Hi, Is there any way to know how many rows the data reader returns after executing a SQL statement? For now, I am doing the follwing: if ...Unanswered | 8 Replies | 6859 Views | Created by Anonymous - Monday, March 22, 2004 3:49 PM | Last reply by Anonymous - Thursday, June 24, 2021 10:24 AM
-
0 Votes
Can't migrate Entity Framework
add-migration FirstAppDemo but keeping <g class="gr_ gr_100 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="100" ...Unanswered | 8 Replies | 3158 Views | Created by Anonymous - Wednesday, July 25, 2018 4:57 PM | Last reply by Anonymous - Tuesday, June 15, 2021 3:24 PM -
0 Votes
Is there a way to get a link query to return a row from a table?
User2130491911 posted So I am trying to access a database table that has a field that I need to match and if there is a match I need to select data out a field in that table. ...Answered | 6 Replies | 1688 Views | Created by Anonymous - Friday, May 28, 2021 9:55 PM | Last reply by Anonymous - Wednesday, June 2, 2021 9:12 PM -
0 Votes
LINQ and Entity Framework errors
User-953209254 posted I have two tables in SQL database: Challenger (ChallengerID, FirstName, LastName, Email) Rank (RankID, ChallengerID, ...Unanswered | 5 Replies | 1073 Views | Created by Anonymous - Thursday, May 27, 2021 6:34 PM | Last reply by Anonymous - Tuesday, June 1, 2021 7:57 AM -
0 Votes
How to use Clause "IN"
!c.Id.Equals(0)).Select(c => c.Id).Distinct().ToList(); RequestEntityDataSource.Where = $"it.Company.Id IN ...Unanswered | 4 Replies | 1156 Views | Created by Anonymous - Friday, May 28, 2021 1:46 PM | Last reply by Anonymous - Tuesday, June 1, 2021 7:53 AM -
0 Votes
Sum and Case to linq
User956519895 posted Need help to convert sql to linq in c# SELECT SUM(CASE WHEN Evaluation.StatusId = 3 THEN 1 END)AS ...Unanswered | 1 Replies | 1850 Views | Created by Anonymous - Monday, May 31, 2021 2:05 PM | Last reply by Anonymous - Tuesday, June 1, 2021 5:59 AM -
0 Votes
listbox does not show the data
User34732094 posted public DataTable getCourses() { string ...Answered | 1 Replies | 1097 Views | Created by Anonymous - Monday, May 31, 2021 7:12 PM | Last reply by Anonymous - Tuesday, June 1, 2021 1:58 AM -
0 Votes
executeScalar method is giving error
User34732094 posted Hi All, public string execCount(string query) { ...Answered | 3 Replies | 1419 Views | Created by Anonymous - Sunday, May 30, 2021 10:44 PM | Last reply by Anonymous - Monday, May 31, 2021 6:03 PM -
0 Votes
Walking into an antipattern? Fetching data multiple FKs many layers deep ...
User-146510594 posted Using SQL and EF Core, I need to efficiently fetch data scattered across many tables. There are ~50 tables, with many tables having multiple ...Unanswered | 6 Replies | 1128 Views | Created by Anonymous - Tuesday, May 25, 2021 4:06 PM | Last reply by Anonymous - Wednesday, May 26, 2021 9:21 AM -
0 Votes
EF Core 5.0.X Model Customizations - database first
User379720387 posted I am modernizing a 4.X aspnet app to Blazor Server/Wasm. In the original app I was using EF 6.4.X and a whole bunch ...Unanswered | 3 Replies | 913 Views | Created by Anonymous - Saturday, May 22, 2021 4:35 PM | Last reply by Anonymous - Sunday, May 23, 2021 10:54 PM -
0 Votes
Editing SQL database items and Model Binding attributes?
User281366353 posted Problem: I want to update an SQL database record and not create a new database entry. The ASP.Net Core MVC application I am working on ...Answered | 1 Replies | 1030 Views | Created by Anonymous - Saturday, May 22, 2021 4:49 PM | Last reply by Anonymous - Saturday, May 22, 2021 5:26 PM -
0 Votes
Linq GroupBy and Sum - .First() could not be translated
User379720387 posted My data is owner, location, date, charge, payment, the plan is to get a list of owners, each having a location, and the Sum OwnerTotal (charge - ...Unanswered | 2 Replies | 4541 Views | Created by Anonymous - Thursday, May 20, 2021 4:32 PM | Last reply by Anonymous - Friday, May 21, 2021 2:41 AM -
0 Votes
Help retrieving columns from StoredProcedure using LINQ...
User-507786106 posted I need to retrieve data by using a stored Procedure using MVC LINQ. I need to retrieve two fields from the table. My method is a ...Answered | 1 Replies | 862 Views | Created by Anonymous - Tuesday, May 18, 2021 12:31 PM | Last reply by Anonymous - Tuesday, May 18, 2021 1:52 PM -
0 Votes
Help with composing async Task<IEnumerable<variables>> .....
User-507786106 posted I must select distinct values from one column named YEAR from the database table. I MUST use async Task<IEnumerable<variables>> for this code ...Answered | 2 Replies | 1033 Views | Created by Anonymous - Monday, May 17, 2021 7:43 PM | Last reply by Anonymous - Monday, May 17, 2021 9:00 PM -
0 Votes
Scaffold common base class for all entities
User-1262787652 posted Creating ASP.NET 5 Core MVC application using Npgsql EF Core provider. Scaffold creates Poco classes like namespace MyDbContext ...Unanswered | 3 Replies | 1038 Views | Created by Anonymous - Monday, May 17, 2021 7:20 AM | Last reply by Anonymous - Monday, May 17, 2021 11:15 AM -
0 Votes
Seeding users using UserManger and Identify role class thinks its a static class
User-183185495 posted I am trying to seed users and permissions but no matter what I do I get the following error. But when you look below at my code not one ...Answered | 1 Replies | 779 Views | Created by Anonymous - Thursday, May 13, 2021 2:06 AM | Last reply by Anonymous - Thursday, May 13, 2021 6:39 AM -
0 Votes
EF Core, first query is slow, how to generate a precompile view to improve performance
User956626884 posted Hi, I am working on webapi 3.1 with entityframework core 3.16. I got about 180 entity that is slow with the first query. I read that ...Answered | 1 Replies | 1424 Views | Created by Anonymous - Thursday, May 6, 2021 6:13 PM | Last reply by Anonymous - Friday, May 7, 2021 8:09 AM -
0 Votes
The instance of entity type cannot be tracked because another instance with the same key value for {'ID'} is already being tracked.
User-1824785574 posted The instance of entity type 'Table' cannot be tracked because another instance with the same key value for {'Id'} is already being tracked. When attaching ...Unanswered | 1 Replies | 14777 Views | Created by Anonymous - Saturday, May 1, 2021 8:42 PM | Last reply by Anonymous - Saturday, May 1, 2021 9:41 PM -
0 Votes
Convert linq to sql query
x.boxId == boxId) .Include(x => x.boxItem).ThenInclude(x => x.boxItemGen) .Include(x => x.boxItem).ThenInclude(x => x.boxItemQ).ThenInclude(x => ...Answered | 2 Replies | 9976 Views | Created by Anonymous - Tuesday, April 27, 2021 9:23 PM | Last reply by Anonymous - Wednesday, April 28, 2021 2:06 AM -
0 Votes
issues in defining relationship between entities in EntityFramework core code first
User1838940990 posted Hi Aall, I am completely new to Entity framework, working on sample app. Following the .entity framework CodeFirst ...Unanswered | 2 Replies | 703 Views | Created by Anonymous - Monday, April 19, 2021 4:15 AM | Last reply by Anonymous - Thursday, April 22, 2021 7:15 AM - Items 1 to 20 of 15061 Next ›
No announcements
