RickyLin

ALTER PROCEDURE [dbo].[spGenerateEntity]
    @TableName AS NVARCHAR(128),
    @NewDateTypes AS BIT = 0
AS
SELECT CASE WHEN COLUMN_NAME = TABLE_NAME + 'Id' THEN '[Column("' + COLUMN_NAME + '")]
public ' ELSE 'public ' END
    + CASE DATA_TYPE WHEN 'int' THEN 'int' 
        WHEN 'money' THEN 'decimal'
        WHEN 'varchar' THEN 'string'
        WHEN 'datetime' THEN 'DateTime'

RickyLin

DECLARE @LogIndex INT
DECLARE @LastCheckDate DATETIME

SET @LogIndex = 0
SET @LastCheckDate = '2023-12-21'

DECLARE @Logs TABLE
(
    LogDate DATETIME,
    ProcessInfo NVARCHAR(4000),

RickyLin

# usage: StopAppPool.ps1 -AppPoolName DefaultAppPool
# set-executionpolicy remotesigned
# Document of WebAdministration:
#     https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee790599(v%3dtechnet.10)
# multiple parameters sample: param([string]$paramA,[string]$paramB)

param([string]$AppPoolName)

if ([string]::IsNullOrEmpty($AppPoolName))
{

RickyLin

using System;
using System.Linq;

namespace SampleTest
{
    public class Program
    {
        public static void Main()
        {
            

RickyLin

/// <summary>
/// Converts characters above ASCII to their ASCII equivalents.  For example, accents are removed from accented characters. 
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
public static string ReplaceDiacritics(this string str)
{
    /* based on code here:
     * https://github.com/apache/lucenenet/blob/master/src/Lucene.Net.Analysis.Common/Analysis/Miscellaneous/ASCIIFoldingFilter.cs
     */

RickyLin

using System;
using System.Linq.Expressions;
using System.Linq;
using System.Collections.Generic;

namespace Rvc.Utilities
{
    // refer to System.Web.Query.Dynamic namespace
    public static class IQueryableExtensions
    {

RickyLin

ALTER DATABASE DatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE DatabaseName SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE DatabaseName SET ONLINE

/* Generate sql scripts for multiple databases.
SELECT 'ALTER DATABASE ' + [name] + ' SET OFFLINE WITH ROLLBACK IMMEDIATE;
ALTER DATABASE ' + [name] + ' SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE ' + [name] + ' SET ONLINE;
'
FROM sys.databases

RickyLin

/*
using Microsoft.EntityFrameworkCore.Diagnostics;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;
*/

public class EnrichExceptionDataDbCommandInterceptor : DbCommandInterceptor

RickyLin

/* The CurrentThreadTaskScheduler code comes from
 * https://github.com/dotnet/samples/blob/main/csharp/parallel/ParallelExtensionsExtras/TaskSchedulers/CurrentThreadTaskScheduler.cs
 */
/// <summary>
/// Provides a task scheduler that runs tasks on the current thread.
/// </summary>
public sealed class CurrentThreadTaskScheduler : TaskScheduler
{
    /// <summary>Runs the provided Task synchronously on the current thread.</summary>
    /// <param name="task">The task to be executed.</param>

RickyLin

/* source: https://stackoverflow.com/a/7124052/2753545 */

function htmlEscape(str) {
    return str
        .replace(/&/g, '&')
        .replace(/"/g, '"')
        .replace(/'/g, ''')
        .replace(/</g, '&lt;')
        .replace(/>/g, '&gt;')
        .replace(/\//g, '&#x2F;');