Tagged articles - Stored Procedure
Found 4 articles tagged with Stored Procedure
12
Mar
2015
Reducing the number of Stored Procedures for the Application
SQL/T-SQL8 titlesApproach to reduce number of stored procedure for the application
0
Nowadays, in the years of ORM, barely anyone thinks about stored procedures, but they are still there and accessing and reading data with ADO and SqlDataReader ist still the fastest way.
Stored procedures are validated, parsed and compiled in SQL server, so these steps are not required to be performed versus plaint text query (which is what entity framework generates for accessing data).
...read more
01
Mar
2015
Super lightweight Data Access Layer returning models from ADO
.NET196 titlesReturn strongly typed objects directly from stored procedure calls
0
Entity framework is an awesome tool for working with database in .net, but sometime you have to get back to old fashion ADO for the performances. The bad thing is that as soon as you get back to ADO, you have to deal with SqlDataReader, DataTable and DataSet classes.
This is not so convenient for using in upper levels of applications, especially in MVC environment where using strongly typed objects is an essential thing.
...read more
24
Feb
2015
Transform comma seperated string to rows in SQL Server
SQL/T-SQL8 titlesUse comma separated string in TSQL
0
Passing complex data to and from stored procedures has always been a tricky one. The most elegant way to pass values to a stored procedure is to use predefined data types in SQL Server...read more
18
Feb
2015
Migrate stored procedures across databases
SQL/T-SQL8 titlesCopy stored procedure from one database to another with T-SQL
0
When working on an app you create all your stored procedures, functions, tables, view and other objects in a development database (or t least it should be like that). A small but annoying problem occurs when you have to migrate your stored procedures to test or production database.
Imagine during development you had let's say 20 stored procedures...read more
.NET
10
Sep
2019
Unit testing repositories in ASP.NET Core with xUnit and Moq
Mocking UserManager RoleManager and DbContext in unit tests in .NET Core
4
Sep
2019
Mixed model binding in ASP.NET Core using custom model binders
IModelBinder interface implementations usage for multiple source model binding
31
Aug
2019
Handling file uploads in Swagger UI with ASP.NET Core
Swagger UI file upload in ASP.NET Core WebApi
28
Aug
2019
Monitoring Redis key events in .NET Core
Key event subscriptions for DEL, SET, EXPIRED key events in Redis using .NET Core
12
Jun
2019
Deploying .NET Core WebJobs to Azure using Azure Build Pipeline
Using Azure Build and Release pipeline to deploy WebJob to a WebApp instance
11
Jun
2019
Writing Azure WebJobs with dependency injection in .NET Core
Take advantage of .NET Core native dependency injection in Azure WebJob
JavaScript
28
Oct
2018
HTML5 localStorage with expiry with vanilla JavaScript
Using HTML5 localStorage with expiry
8
May
2018
Monitoring DOM changes with JavaScript
Handling DOM changes with plain JavaScript
9
May
2017
Non blocking CSS load on the page
Load external CSS files in an async manner
16
Mar
2017
Serialize html form to JSON without using JQuery
Transform user input from HTML form fields to JSON
17
Jan
2016
Copy text value to clipboard using jQuery
Simple sample of using jQuery to copy value to clipboard
11
Jan
2016
Resize image on the client side with JQuery
Reducing the upload sie by resizing image on the client side
SQL/T-SQL
3
May
2018
Reading JSON data in T-SQL on SQL Server
Extracting values from JSON string on SQL Server using T-SQL
28
Apr
2016
Create XML/HTML with T-SQL
Generating XML/HTML output in SQL Server
24
Nov
2015
IP address to octets split in TSQL
Split IP addresse into octets in SQL Server
20
Jul
2015
Getting first and last second of the current year, month and day
Using minimum and maximum date time in SQL query
13
Apr
2015
Dealing with duplicate rows in SQL Server
Finding and cleaning up duplicate rows in SQL Server tables
12
Mar
2015
Reducing the number of Stored Procedures for the Application
Approach to reduce number of stored procedure for the application
Umbraco CMS
2
Mar
2018
Minify HTML output of your pages
Minification of HTML output using ASP.NET IHttpModule
18
Apr
2015
Generate sitemap.xml on the fly in Umbraco CMS
Simple sitemap.xml Umbraco handler
2
Mar
2015
Accessing UmbracoHelper in HttpHandler request
Working with UmbracoHelper and IPublishedContent in HttpHandler
14
Sep
2014
Same page language switching in Umbraco
Land on the same page in different language in Umbraco using Relations
4
Sep
2014
Getting cropped image the smart way
The way to get cropped image URL with option to load original image too
27
Aug
2014
Fastest way to return JSON result from a controller
Resturn JSON in MVC controller action