ASP.NET Core 7.0 API Error

Question

ASP.NET Core 7.0 API Error

thanhsang Thach 1

public class DataDepartment
{
public string? Dept_ID { get; set; }
public string? Dept_Name { get; set; }
public DateTime Modify_Date { get; set; }
public bool? Hide { get; set; }
}

Connection String:
"DBSettingConnection": "Data Source=####;Initial Catalog=####;User Id=####;Password=####;Integrated Security=True;Encrypt=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"

When execute: Error: Internal Server Error

266745-response-1670055658700.txt

And try setting TreatTinyAsBoolean=false in connection string
Error:
266833-response-1670055525026.txt

Viorel 122.6K Reputation points

2022-12-03T08:50:18.997+00:00

What did you execute?
thanhsang Thach 1 Reputation point

2022-12-05T00:51:45.173+00:00

Debug with web browser

Error 1: Internal Server Error

Error 2: try setting TreatTinyAsBoolean=false in connection string
Jack J Jun 25,296 Reputation points

2022-12-05T09:15:27.07+00:00

@thanhsang Thach , Welcome to Microsoft Q&A, based on the error Unable to cast object of type 'System.Boolean' to type 'System.String', I guess there is a type conversion problem. Could you provide the related code about your problem? Also, you could try to use try catch to location where is the problem.
thanhsang Thach 1 Reputation point

2022-12-05T09:32:33.98+00:00

dbData\Entities\clsData_Department.cs

267092-clsdata-department.txt

dbData\cls_dbHRIS_Context.cs
267117-cls-dbhris-context.txt

and Controllers\Data_DepartmentController.cs
267196-data-departmentcontroller.txt
Jack J Jun 25,296 Reputation points

2022-12-06T05:37:42.547+00:00

@thanhsang Thach , thanks for the feedback, based on my test, the code you provided works for me. Maybe there are some problems in your database. Could you provide your database data and database design?
thanhsang Thach 1 Reputation point

2022-12-07T15:14:00.623+00:00
database data
268228-db-data-department.txt

database design

268281-sql-data-department.txt
Jack J Jun 25,296 Reputation points

2022-12-08T09:01:54.293+00:00
@thanhsang Thach , thanks for the feedback, after my further testing, the code still works for me.
Then, I suggest that you could check the following things:
First, you could set the break point in the following picture to check if the current point has the problem.

Second, you could check your connection string again like the following code:

string connstr = "yourstr"; SqlConnection connection = new SqlConnection(connstr); connection.Open(); var t = connection.State;
thanhsang Thach 1 Reputation point

2022-12-08T11:10:42.563+00:00

thanks for the feedback. I'll do it.
Jack J Jun 25,296 Reputation points

2022-12-15T06:19:18.87+00:00

@thanhsang Thach , is any update, did you find the solution about your problem?

1 answer

Your answer

Viorel 122.6K Reputation points

2022-12-03T08:50:18.997+00:00

What did you execute?
thanhsang Thach 1 Reputation point

2022-12-05T00:51:45.173+00:00

Debug with web browser

Error 1: Internal Server Error

Error 2: try setting TreatTinyAsBoolean=false in connection string
Jack J Jun 25,296 Reputation points

2022-12-05T09:15:27.07+00:00

@thanhsang Thach , Welcome to Microsoft Q&A, based on the error Unable to cast object of type 'System.Boolean' to type 'System.String', I guess there is a type conversion problem. Could you provide the related code about your problem? Also, you could try to use try catch to location where is the problem.
thanhsang Thach 1 Reputation point

2022-12-05T09:32:33.98+00:00

dbData\Entities\clsData_Department.cs

267092-clsdata-department.txt

dbData\cls_dbHRIS_Context.cs
267117-cls-dbhris-context.txt

and Controllers\Data_DepartmentController.cs
267196-data-departmentcontroller.txt
Jack J Jun 25,296 Reputation points

2022-12-06T05:37:42.547+00:00

@thanhsang Thach , thanks for the feedback, based on my test, the code you provided works for me. Maybe there are some problems in your database. Could you provide your database data and database design?
thanhsang Thach 1 Reputation point

2022-12-07T15:14:00.623+00:00

database data
268228-db-data-department.txt

database design

268281-sql-data-department.txt
Jack J Jun 25,296 Reputation points

2022-12-08T09:01:54.293+00:00

@thanhsang Thach , thanks for the feedback, after my further testing, the code still works for me.
Then, I suggest that you could check the following things:
First, you could set the break point in the following picture to check if the current point has the problem.

Second, you could check your connection string again like the following code:

string connstr = "yourstr"; SqlConnection connection = new SqlConnection(connstr); connection.Open(); var t = connection.State;
thanhsang Thach 1 Reputation point

2022-12-08T11:10:42.563+00:00

thanks for the feedback. I'll do it.
Jack J Jun 25,296 Reputation points

2022-12-15T06:19:18.87+00:00

@thanhsang Thach , is any update, did you find the solution about your problem?

Answer 1

thanhsang Thach 1

Tks your feedback.
In database has somes row is not null[Null] it's ''
I updated it's to null[Null] and it's work ok.

Tks.

Share via

ASP.NET Core 7.0 API Error

1 answer

Your answer