All Questions
12,723 questions
-1
votes
1
answer
61
views
ArgumentNullException in MySql HealthCheck before building Asp.Net Core application
I have a dotnet 8 asp core application and I'm trying to add a HealthCheck for my Azure Database using AspNetCore.HealthChecks.MySql nuget and retreiving connection string from Azure App Configuration ...
- 321
2
votes
1
answer
104
views
Using Entity Framework method ExecuteUpdate: Set current property value to another property
With the code fragment below, I would like to update the status properties of multiple database records, for example bookings.
Each record has the properties StatusCurrent and StatusBefore. I would ...
- 21
0
votes
1
answer
86
views
Bulk Inserts and Retrieving Last Inserted c# mysql
I'm facing an issue in my C# application where I need to insert bulk data into a MySQL table and retrieve the last inserted ID for each row. I have two approaches to handle this, and I’m unsure which ...
3
votes
1
answer
240
views
MySql EFCore 9 Contains in array issue
I am trying to do a contains list linq sql query to a MySql database and the query cannot be translated to SQL. This same query works when using the SQLServer.
var arr = new long[] { 5, 3, 2 };
var ...
- 63
0
votes
0
answers
25
views
(Asp.NET C#) Error with executing an update query for a database [duplicate]
I am new to programming, so please be kind. I am working on a final project for C# specifically within ASP.NET. For this project it has been a three part cumulative of CRUD. We are working with a ...
0
votes
0
answers
40
views
How to Handle “Field ‘courseid’ doesn’t have a default value” in MySQL with Manual CourseId Entry?
I am working on a .NET Core Web API project with MySQL as the database. In my database table courses, the courseid field is set as the primary key but does not have the AUTO_INCREMENT attribute.
The ...
0
votes
1
answer
117
views
Why does this ASP.NET MVC controller hang the AppPool in IIS?
This is in C# ASP.NET MVC 5 with Entity Framework 6, .NET 4.8, MySql, IIS.
I seem to be getting a race condition here:
LogErr("set AppAgent start");
_AppWebsite = db.Websites
...
- 2,291
0
votes
0
answers
14
views
How to Transfer Data from DataGridViewRow to MySql Workbench
I can just transfer all the data, but there is a problem in categoryproces I need to transfer a table with duplicate data there are only 3 values out of 97 duplicates. How do I do this?
foreach (...
- 1
0
votes
0
answers
71
views
Access denied for MySqlBulkCopy in AWS RDS [duplicate]
I'm trying to use MySqlBulkCopy to load data from a DataTable in a C# program using the MySqlConnector package:
using (var conn = new MySqlConnection(_connectionString + ";AllowLoadLocalInfile=...
- 3,954
0
votes
0
answers
184
views
Export files to Excel XLSX file using C# and ClosedXML.Excel
I have a problem with exporting my data to Excel XLSX format using C# ASP.Net and ClosedXML.Excel
In practice when I execute the stored procedure "sProc_20241009" on the MySQL DB I have this ...
- 2,115
0
votes
1
answer
56
views
How to connect to MySQL on AWS by C#?
We are figuring out the following small example from an online source about connecting to AWS by C#:
...
try
{
var ssmClient = AwsConnection.ConnectToAWSByVariables(
accessKeyId: ...
- 85
0
votes
1
answer
81
views
How to retrieve a lot of data in my asp .NET app efficiently?
and thanks for paying attention to my issue
Im trying to make a dashboard which shows every notable data in the team (created sales, lost sales, average response and so on).
So on the Controller I ...
- 31
0
votes
0
answers
97
views
How to connect an c# Web-API, which runs on a IONOS windows Server, to a IONOS mySQL database
I want to run a c# Web-API on my IONOS Windows Server. The Web-API should deal with inquiries from Desktop App's and a Webpage. In order to provide this service I want to connect my API with a mySQL ...
- 1
0
votes
1
answer
82
views
Model for MySQL 8.0 Stored Procedure
I created a query in MySQL 8.0.
I want to create a Model class for the below query:
call rep_getusercheckinsperday(2024,9,'XXX');
result 1 - 2024-09
call rep_getusercheckinsperday(2024,10,'XXX');
...
- 1
0
votes
0
answers
25
views
populating C# Winform DatagridView from MySQL but the records are per row (transposed) [duplicate]
Description
Code
Debit
Credit
Electricity Expenses
101020220
1,000.00
Rent Expenses
10102030
5,000.00
Fuel and Oil
110201010
2,000.00
Receivables
10301020
8,000.00
Grand Total
8,000.00
8,000.00
I ...
- 1