Instantly share code, notes, and snippets.

View EntityBuilder.cs
using System;
using System.Collections.Generic;
using System.Reflection;
using System.Reflection.Emit;
namespace EntityBuilder
{
internal class EntityBuilder
{
private readonly IDictionary<string, Type> _cache;
View DataChecker.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace DictionarySwitch
{
public class DataChecker
{
View Program.cs
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();
View Controller.cs
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" };
}
View Startup.cs
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",
View truncate.sql
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),
View columnSearch.sql
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;
View detectBlocking.sql
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
View getFullyQualifiedName.sql
create function dbo.getFullyQualifiedName(
@objectid int
) returns sysname
begin
declare @fqn sysname
select
@fqn = CONCAT(
QUOTENAME(@@SERVERNAME), '.',
QUOTENAME(DB_NAME()), '.',
View NightmareJSInfiniteScroll.js
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);
}