Manually create the SQL Server tables used by de SimpleMembershipProvider

  Below you will find the t-sql code needed to generate de SQL Server SimpleMembershipProvider tables.     set ansi_nulls on go set quoted_identifier on go if object_id(‘dbo.webpages_Membership’) is null begin create table dbo.webpages_Membership ( UserId int not null constraint PK_Membership_UserId primary key, CreateDate datetime null, ConfirmationToken nvarchar(128) null, IsConfirmed …

How to convert a JSON string, containing UTC datetime to a local server datetime string in C#

using Microsoft.VisualStudio.TestTools.UnitTesting; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Diagnostics; using System.IO; using System.Text.RegularExpressions; namespace Research.Rli.Tests { [TestClass] public class ResearchTester { [TestMethod] public void Test() { string json = @"{""date"":""2013-04-10T14:52:43.207Z""}"; Dto dto = JsonConvert.DeserializeObject<Dto>(json); string localTime = dto.date.ToLocalTime().ToString(); Assert.AreEqual("10-4-2013 16:52:43", localTime); // In the Netherlands this test will succeed. …

Installing SSIS support in Microsoft Visual Studio 2012

As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012   You can download Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 at: http://www.microsoft.com/en-us/download/details.aspx?id=36843   On installation I got the following error: …