paully21

Recently created

Least recently created

Recently updated

Least recently updated

joey-qc / TSQL-to-POCO

Created September 26, 2013 06:56

A simple TSQL script to quickly generate c# POCO classes from SQL Server tables and views. You may tweak the output as needed. Not all datatypes are represented but this should save a bunch of boilerplate coding. USAGE: Run this query against the database of your choice. The script will loop through tables, views and their respective columns. Re…

	declare @tableName varchar(200)
	declare @columnName varchar(200)
	declare @nullable varchar(50)
	declare @datatype varchar(50)
	declare @maxlen int

	declare @sType varchar(50)
	declare @sProperty varchar(200)

	DECLARE table_cursor CURSOR FOR

jferguson / gist:1681480

Created January 26, 2012 07:12

SqlBulkCopy Generic List<T>

	public static void BulkInsert<T>(string connection, string tableName, IList<T> list)
	{
	using (var bulkCopy = new SqlBulkCopy(connection))
	{
	bulkCopy.BatchSize = list.Count;
	bulkCopy.DestinationTableName = tableName;

	var table = new DataTable();
	var props = TypeDescriptor.GetProperties(typeof(T))
	//Dirty hack to make sure we only have system data types

SLaks / RoutingExtensions.cs

Created September 18, 2011 22:48

Default Controllers in ASP.Net MVC

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Reflection;
	using System.Web;
	using System.Web.Mvc;
	using System.Web.Routing;

	namespace SLaks.Web.Mvc {
	//http://blog.slaks.net/2011/09/using-default-controller-in-aspnet-mvc.html