_vegabyte_
_vegabyte_
PostsComments
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
Question. I have only one DTO for this query. Is it okay to leave the other data null, or should i only return what is needed?
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
But they are all related
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
No, I can retrieve the data without the other data from tab 1.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
so In the same query I need a filter based on tab?
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
Is there any way to get those information without compromising the performance?
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
No description
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
This query is already on a pagination and has filter based on requirements.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
No description
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
Currently we don't have any db admin. All the works for the system is done by only two devs.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
I will follow your instructions. I will use Entity Framework to generate the SQL query and then take that query to SQL Server Management Studio (SSMS) analyze the execution plan. If I encounter any issues or have further questions, I'll reach out to you for guidance.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
The query is filtered based on the role of the User then other condition will apply based the requirements supplied on the request. But since this is a client all the information will be fetch.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
I don't have excution plans for this query.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
It's like I'm getting all the information in a single query. Like Approvals, Request, Items and other information.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
I'll try to create a diagram for this one. For more information about my database.
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
Is there any way or other approach?
47 replies
CC#
Created by _vegabyte_ on 1/24/2024 in #help
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation"
Hahaha. I need all the data for that. Like all data is needed.
47 replies
CC#
Created by _vegabyte_ on 11/22/2023 in #help
Proper way to access Navigational Properties
No description
27 replies
CC#
Created by _vegabyte_ on 11/22/2023 in #help
Proper way to access Navigational Properties
Sorry I posted incomplete code. hehe
27 replies
CC#
Created by _vegabyte_ on 11/22/2023 in #help
Proper way to access Navigational Properties
Like registration status : Under review Approved Rejected
27 replies
CC#
Created by _vegabyte_ on 11/22/2023 in #help
Proper way to access Navigational Properties
No description
27 replies