DCCoder90

using System;
using System.Collections.Generic;
using System.Reflection;
using System.Reflection.Emit;

namespace EntityBuilder
{
    internal class EntityBuilder
    {
        private readonly IDictionary<string, Type> _cache;

DCCoder90

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DictionarySwitch
{
    public class DataChecker
    {

DCCoder90

using System;
using Microsoft.Owin.Hosting;

namespace SelfHosted{
  class Program{
    static void Main(string[] args){
      using (WebApp.Start("http://localhost:8080")){
        Console.WriteLine("Web Server is running.");
        Console.WriteLine("Press any key to quit.");
        Console.ReadLine();

DCCoder90

using System.Collections.Generic;
using System.Web.Http;

namespace SelfHosted{
  public class HelloController : ApiController{
    // GET api/hello
    public IEnumerable Get(){
      return new string[] { "Hello", "World" };
    }

DCCoder90

using System.Web.Http;
using Owin;

namespace SelfHosted{
  public class Startup{
    public void Configuration(IAppBuilder app){
      // Configure Web API for self-host.
      var config = new HttpConfiguration();
      config.Routes.MapHttpRoute(
        name: "DefaultApi",

DCCoder90

SET NOCOUNT ON
GO

DECLARE @table TABLE(
RowId INT PRIMARY KEY IDENTITY(1, 1),
ForeignKeyConstraintName NVARCHAR(200),
ForeignKeyConstraintTableSchema NVARCHAR(200),
ForeignKeyConstraintTableName NVARCHAR(200),
ForeignKeyConstraintColumnName NVARCHAR(200),
PrimaryKeyConstraintName NVARCHAR(200),

DCCoder90

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%COLUMN NAME%'
ORDER BY    TableName
            ,ColumnName;

DCCoder90

SELECT blocked_query.session_id AS blocked_session_id,

blocking_query.session_id AS blocking_session_id,

sql_text.text AS blocked_text,

sql_btext.text AS blocking_text,

waits.wait_type AS blocking_resource

DCCoder90

create function dbo.getFullyQualifiedName(
 @objectid int
) returns sysname
begin

 declare @fqn sysname
 select
  @fqn = CONCAT(
   QUOTENAME(@@SERVERNAME), '.',
   QUOTENAME(DB_NAME()), '.',

DCCoder90

  var previousHeight, currentHeight=0;
  while(previousHeight !== currentHeight) {
    previousHeight = currentHeight;
    var currentHeight = yield nightmare.evaluate(function() {
      return document.body.scrollHeight;
    });
    yield nightmare.scrollTo(currentHeight, 0)
      .wait(3000);
  }