
Image from Pexels
Tagged articles - ADO
Found 5 articles tagged with ADO
02
Feb
2016
Serialize DataTable to JSON with just few lines of code
.NET217 titlesGenerate JSON string from DataTable in C#
0
Although JSON is widely used as a format for sharing the data, there are still existing solutions or modules that still rely on ADO and DataTables. Even today it very common to see some piece of code which deals with DataTable or DataReader for the performance reasons.
In the end if any of the ADO objects needs to be exposed as a JSON string you have to write your own serialization code.
...read more
03
Jan
2016
SqlBulkCopy with model classes in C#
.NET217 titlesUse SqlBulkCopy with model (POCO) classes in C#
0
So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable...read more
02
Jun
2015
Easy and simple way to bind ADO object to POCO object
.NET217 titlesSimple one way binding of ADO database objects to POCO
0
This article is base don the article I wrote in September last year. Basically I wrote this piece of code because I needed something really lite for one way binding...read more
01
Mar
2015
Super lightweight Data Access Layer returning models from ADO
.NET217 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...read more
24
Feb
2015
Transform comma seperated string to rows in SQL Server
SQL/T-SQL9 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
.NET
19
Dec
2020
Setting up SQL Server IDistributedCache with migration in ASP.NET Core
Embedding SQL Server caching in a project with EFCore migration
11
Dec
2020
Representing available string values for parameters as list in Swagger ASP.NET Core
Valid values as list in Swagger UI in ASP.NET Core
24
Nov
2020
Running multiple queries at the same time in EF Core
Overcoming the limitation of EF Core query execution
17
Nov
2020
Accessing multiple databases from the same DbContext in EF Core
Multiple database access from the same DbContext in Entity Framework Core 5
11
Sep
2020
Building and using advanced .NET Core CLI global tools
Handling commands, arguments and options in .NET CLI global tool application
6
Sep
2020
Seeding data in EF Core using SQL scripts
Another way of seeding data in EF Core
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
23
May
2020
Identifying opened connections for the specific application in SQL Server
Connection listing queries in SQL Server
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
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