yngwie74

 DECLARE @table TABLE
  (
      SPID        INT
     ,Status      VARCHAR(15)
     ,[Login]     VARCHAR(30)
     ,HostName    VARCHAR(MAX)
     ,BlkBy       VARCHAR(10)
     ,DBName      VARCHAR(15)
     ,Command     VARCHAR(MAX)
     ,CPUTime     INT

yngwie74

// forma tradicional, agregando los elementos uno a uno
private IDictionary<int, DateTime> GetDiccionaryOriginal(int[] keys)
{
    var result = new Dictionary<int, DateTime>();

    using (var context = DataContextFactory.MyContext)
    {
	context.MY_RECORDs.Where(r => keys.Contains(r.RECORD_ID))
	   .ToList()
	   .ForEach(r => result.Add(r.RECORD_ID, r.LATEST_UPDATE_TS));

yngwie74

SELECT name
      ,create_date
      ,modify_date
  FROM sys.tables
 WHERE name = 'TABLE_NAME'

yngwie74

SELECT rsh.destination_database_name AS [Database]
      ,rsh.user_name                 AS [Restaurado por]
      ,CASE
          WHEN rsh.restore_type = 'D' THEN 'Database'
          WHEN rsh.restore_type = 'F' THEN 'File'
          WHEN rsh.restore_type = 'G' THEN 'Filegroup'
          WHEN rsh.restore_type = 'I' THEN 'Differential'
          WHEN rsh.restore_type = 'L' THEN 'Log'
          WHEN rsh.restore_type = 'V' THEN 'Verifyonly'
          WHEN rsh.restore_type = 'R' THEN 'Revert'

yngwie74

using System.Diagnostics;

class MiClase
{
      private void MiFuncion()
      {
          var sw = new Stopwatch();
          sw.Start();

          // Tu código va aquí

yngwie74

        private TRet WithLogging<T, TRet>(T context, string logmsg, Func<T, TRet> func) where T : DataContext
        {
            TRet result;

            var log = context.Log;
            var builder = new StringBuilder();
            try
            {
                context.Log = new StringWriter(builder);

yngwie74

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

namespace ViveCodigo.Katas.LCD
{
    /// <summary>
	/// Basado en la idea original de @rodrigo_salado
    /// </summary>
    public class LCD
    {

yngwie74

using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace ViveCodigo.Katas.LCD.Test
{
    /// <summary>
    ///This is a test class for LCDTest and is intended to contain all its Unit Tests.
    ///</summary>
    [TestClass]
    public class LCDTest
    {

yngwie74

package org.vivecodigo.katas.lcd;

import java.util.*;

public class LCD {

	private static final String _NONE = "   ";
	private static final String _LEFT = "  |";
	private static final String _MIDL = " _ ";
	private static final String _MDLT = " _|";

yngwie74

package org.vivecodigo.katas.lcd;

import static junit.framework.Assert.*;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.Suite;

@RunWith(Suite.class)
@Suite.SuiteClasses( { AllTests.TestUtils.class, AllTests.LCDTests.class })