.NET Core and ASP.NET Core offer several advantages over traditional .NET development. You should use .NET Core for your server applications if some or all of the following are important to your application’s success:
- Use of microservices
- Use of Docker containers
- High performance and scalability requirements
Side-by-side versioning of .NET versions by application on the same server
There are two supported implementations for building server-side applications with .NET: .NET Framework and .NET Core. Both share many of the same components and you can share code across the two. However, there are fundamental differences between the two and your choice depends on what you want to accomplish. This article provides guidance on when to use each.
EPi.Extensions is library with useful extension methods and helpers for EPiServer.
The following SQL will get you the row count of all tables in a database:
1234567891011 CREATE TABLE #counts(table_name varchar(255),row_count int)EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESCDROP TABLE #counts
The output will be a list of tables and their row counts.
If you just want the total row count across the whole database, appending:
123 SELECT SUM(row_count) AS total_row_count FROM #counts
will get you a single value for the total number of rows in the whole database.
…there are a few options that can help us to downgrade the database from a higher version of SQL Server to a lower version SQL Server. These options include:
- Generate Scripts wizard of SQL Server Management Studio
- SQL Server Integration Services
- Custom scripting and BCP
In this tip we will use the Generate Scripts wizard of SQL Server Management Studio.
“In a constant battle to reduce the amount of duplication and technical debt in the code I write, I am always revisiting code and looking at how I can reduce the amount of maintenance work I need to perform.”
I had a bunch of png images in several subfolders which I wanted to convert into jpg.
I used the command line tool ImageMagick for Windows, which is free and can be downloaded here:
Download @ ImageMagick
This command will convert all images in the folder and its subfolders from png to jpg with quality 65. The converted files will get the same filename but with jpg extension:
for /R %f in (*.png) do ( convert -quality 65 "%f" "%~npf.jpg" )
convert is the ImageMagick command running, for /R is used for looping recursively.
Use this command when done to remove all the source png files:
del *.png /s
This will delete all png files in this folder and all subfolders.
Re: how to increase upload size of a documnet upto 20 MB….in an asp.net application. Aug 04, 2013 08:25 AM|LINK You likely will need to update your maxRequestLength within your web.config to handle files and uploads that are large (as the default limit is often 4MB). This can be handled within the section of your web.config or the section if you want to handle it at the IIS level (both are probably a good idea). It’s important to know that maxAllowedContentLength is measured in bytes and maximumRequestLength is measured in kilobytes when settings these values so you’ll need to adjust them accordingly if you plan on handling much larger files : If you wanted to use 20MB as a limit, you would need to change the values to the following respectively : If you don’t see these sections within your existing web.config file, you’ll simply need to copy them in. Updating the maxRequestLength property is likely going to be the easiest method of handling this, however there are alternatives such as libraries like NeatUpload, which are designed to handle large files and can handle uploading files as streams to your preferred method of storage.
I needed to search in all tables for a certain GUID, I used this SP in MS SQL Server 2016: Find a GUID (or anything) in ANY table in your database! | CSharpner.com