All Questions
Tagged with sql-server asp.net-mvc
3,298
questions
0
votes
1
answer
46
views
In web applications how to hide the sensitive data from software developers [closed]
We are developing an ASP.NET Core application using the MVC framework and SQL Server database. The application is intended for board members, and it's crucial that sensitive data remains inaccessible ...
0
votes
1
answer
64
views
Unable to create a 'DbContext' of type NULL. The exception 'Object reference not set to an instance of an object.'
I have a problem with add-migration for my database in ASP.NET Core 8.0.
Here is the code
ApplicationDbContext:
public ApplicationDbContext(DbContextOptions<DbContext> options) : base(...
1
vote
0
answers
64
views
Resolving Time Difference Issue in SQL Server and .NET
I'm encountering an issue with time differences in my SQL Server environment and I'm seeking advice on how to resolve it. Here's a brief overview of the problem:
Problem Description:
I have a scenario ...
0
votes
1
answer
81
views
The query performs significantly slower when executed from ASP.NET MVC web app compared to directly on SQL Server
I am experiencing a notable performance issue with a SQL query when it is executed from an ASP.NET MVC web app compared to running it directly on the database.
The query is supposed to retrieve ...
1
vote
1
answer
70
views
SQL created unwanted column for one to many relationship
I'm using ASP.NET MVC to setup a database, but when I run update-database, the database automatically created another column JobListingJobId to store the FK of the JobApplication table.
Here are all ...
0
votes
2
answers
72
views
ASP.NET MVC on .NET 4.8 website doesn't display all pages on Azure App Service
ASP.NET MVC works fine on local machine but once deployed on Azure App Service, the pages related to a writing operation on the database do not display (pages that add data to the database and pages ...
-1
votes
1
answer
60
views
Run a script that checks for SQL Server changes that returns a boolean value
I already plan on doing this differently with webhooks, but for now I just need to show a PoC for this where the browser client will check on intervals if there's any changes to an SQL Server database ...
0
votes
0
answers
52
views
Linear Guage Chart in ASP.NET MVC forms fetching data from SQL Server using anychart.com charting library
Question
How can I create a covid linear gauge chart with LED and bar pointers to visualize progress in a C# ASP.NET web application using the AnyChart.com library, and how do I fetch the data from an ...
0
votes
2
answers
50
views
ASP.NET MVC role is trying to use SQL Server Express not the SQL Server
I have the following in my web.config file
<configuration>
<connectionStrings>
<add name="DefaultConnection"
connectionString="Data Source=...
0
votes
0
answers
83
views
Fetching and Displaying Invoice Details in ASP.NET MVC
Upon clicking on an Order No in filetredaddressdetails view, the application should redirect to the invoice view through orderid. The Order ID serves as a primary key in the Orders table, which helps ...
1
vote
2
answers
182
views
Trying to Insert Bulk record into the database at once using C# and MS SQL User-Defined Table type
I have written below C# code and SQL code; I got scenario to insert multiple records in database at once, so I tried below method, but it is not working from my MVC C# but when I fire query manually ...
0
votes
0
answers
78
views
Error when connecting ASP.NET MVC Docker database
When trying to connect a project with an ASP.NET MVC and Docker database, I get this error:
Microsoft.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while ...
0
votes
1
answer
91
views
Large Data Download Using XLWorkbook in C# but Memory Issue
I am looking for a solution to download large data in Excel using C#.
I am using XLWorkbook library but memory issue I have 100M data so local memory full and performance slow in my system.
Are there ...
0
votes
1
answer
94
views
C# MVC Function that calls stored procedure but it always returns empty
I'm currently working on a function that calls a stored procedure that for some reason will always return empty for me. This stored procedure works when I run it manually inside SMSS, but for some ...
0
votes
0
answers
35
views
Updating form in ASP.NET MVC
When I insert or update one form I have error:
Spatial types and functions are not available for this provider because the assembly 'Microsoft.SqlServer.Types' version 10 or higher could not be found
...