Secure DAL Design using Stored Procedures
I normally avoid sProcs as much as possible. I dont like the language be it TSQL or PL/SQL; they seem archaic against Java/Dot-Net which I use. I go for them when a routine needs to fetch a lot of data, crunch it and generate a small set of output. Sitting inside the DB makes the fetching process a lot fast, no network hit. But that is all.
A CLR SQL Server Stored Procedure calling an ASP.NET Web API
We are developing a big system with SQL Server database, ASP.NET Web API 2.2 services and another external services.
A CLR SQL Server Stored Procedure calling an ASP.NET Web API
We are developing a big system with SQL Server database, ASP.NET Web API 2.2 services and another external services.
Stored procedure with output parameters in MSSQL
I want a stored procedure that retrieves ID and PID from the invoice table with batchid as input parameter and based on the retrieved PID I want to retrieve sid from the log table.
In total I want to retrieve 3 parameters – ID, PID and SID
Stored procedure withoutput parameters in MSSQL
I want a Stored procedure that retrieves ID and PID from the invoice table with batchid as input parameter and based on the retrieved PID I want to retrieve sid from the log table.
In total I want to retrieve 3 parameters – ID, PID and SID
Directly query database vs. Using web service
I’m a junior programmer, am working on a WPF application that will deploy to ~50 users.