theorigin

-- Tables
-- Basically the table name (singular)

CREATE TABLE [dbo].[Product] (...)



-- Columns
-- Identity
[Id] INT NOT NULL IDENTITY (1, 1) -- Id column with auto increment 

theorigin

Using MyReader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser("C:\testfile.txt")
   MyReader.TextFieldType = FileIO.FieldType.Delimited
   MyReader.SetDelimiters(",")
   Dim currentRow As String()
   While Not MyReader.EndOfData
      Try
         currentRow = MyReader.ReadFields()
         Dim currentField As String
         For Each currentField In currentRow

theorigin

declare @p2 dbo.Dictionary
insert into @p2 values(N'orderReference',N'654')
insert into @p2 values(N'earliestRequestedDeliveryDate',N'2013-09-02')
insert into @p2 values(N'transactionId',N'123')

declare @p3 dbo.IndexedDictionary
insert into @p3 values(1,N'productCode',N'59510')
insert into @p3 values(1,N'orderedQty',N'1')
insert into @p3 values(2,N'productCode',N'62754')
insert into @p3 values(2,N'orderedQty',N'3')

theorigin

private IEnumerable<Dictionary<string, object>> DataSetToOrder(DataSet orderDetails)
        {            
            var s = orderDetails.Tables[0].Rows[0][0].ToString();

            var tableDefinitions = s.Replace(", ", ",").Split(',');

            var tables = tableDefinitions.Select(tableDefinition => tableDefinition.Split('/')).Select(temp => new Tuple<int, int, string>(int.Parse(temp[0]), int.Parse(temp[1]), temp[2])).ToList();

            var parent = tables.First(t => t.Item1.Equals(1));

theorigin

namespace VS.Library.Interfaces
{
    using System.Collections.Generic;
    using System.IO;
    using System.Security.AccessControl;

    public interface IDirectory
    {
        bool Exists(string path);

theorigin

namespace namespace VS.Library.Interfaces
{
    public interface IFile
    {
        void Move(string sourceFileName, string destFileName);

        bool Exists(string fileName);

        void Delete(string fileName);
    }

theorigin

CREATE PROCEDURE [dbo].[xxx]	
AS
BEGIN	
	SET NOCOUNT ON;
	
	DECLARE @transactionName VARCHAR(32) = REPLACE((CAST(NEWID() AS VARCHAR(36))),'-','')
	
	BEGIN TRY
		
		DECLARE @TranCounter INT;

theorigin

SELECT 
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB, 
    SUM(a.used_pages) * 8 AS UsedSpaceKB, 
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM 
    sys.tables t
INNER JOIN      

theorigin

public static class UrlHelperExtensions
{        
    public static string ContentWithHash(this UrlHelper urlHelper, string contentPath)
    {
        var virtualFile = urlHelper.Content(contentPath);

        var actualFile = urlHelper.RequestContext.HttpContext.Server.MapPath(contentPath);

        var creationDateTime = (File.Exists(actualFile) ? File.GetLastWriteTimeUtc(actualFile) : new DateTime()).ToString("yyyyddMMHHmmss");

theorigin

{
    "$schema": "http://json-schema.org/draft-03/schema#",
    "type": "object",
    "properties": {

        "orderDate": {
            "type": "string",
            "format": "date"
        }
    }