Posts by Davi GN • 133 points
6 posts
-
3
votes2
answers1269
viewsQ: Save without accents and uppercase SQL Server
I’m creating a database, where I need to save all fields in uppercase. Searching the internet, I found the following collate that would work, but it still keeps saving with accents and in upper and…
-
0
votes0
answers420
viewsQ: Trust Level error when publishing MVC application
I need to publish an ASP.NET MVC application on a Locaweb server. But when publishing, the server displays the following message: I tried to tag <securityPolicy> <trustLevel name="Medium"…
-
4
votes1
answer308
viewsQ: How to cast exception in SQL and treat in C#
I’m creating procedures in an SQL Server database. To clear a brand, I first check if the brand is already tied to a product before deleting. CREATE PROCEDURE SP_Delete_MarcasProdutos @Id int AS…
-
1
votes1
answer185
views -
4
votes1
answer1002
viewsQ: Connect to SQL Server on remote server
I need to connect to an SQL Server service on a remote server via Sqlconnection, C#. Initially, it was not possible to find the server, but I solved this by modifying the hosts file of system32,…
-
-3
votes2
answers547
viewsQ: Create Bank Automatically with Code First
I am creating an ASP.NET MVC application with Code First. This system is trade management software. I’d like to separate the information from each company, not leave it all in the same bank. We…