osmyn

<script>
var CookieMonster = (function() {
  
  return {
    checkCookie: checkCookie,
    getCookie: getCookie,
    setCookie: setCookie,
    deleteCookie: deleteCookie
  };
  

osmyn

<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>Async Unit Test</Title>
      <Author>Rusty Divine</Author>
      <Description>Async Unit Test Template with 3 Parts</Description>
      <HelpUrl>https://msdn.microsoft.com/en-us/library/ms165394.aspx</HelpUrl>
      <SnippetTypes />
      <Keywords />

osmyn

public class LocationServiceBuilder
{
    //create default behaviors
    IHttpService _httpService = Mock.Create<IHttpService>();
    IFileService _fileService = Mock.CreateLike<IFileService>(fs => fs.ReadAllLines(Arg.AnyString) == new string[] { "key" });

    //pass in your own dependency if needed
    public LocationServiceBuilder WithHttpService(IHttpService httpService)
    {
        _httpService = httpService;

osmyn

WITH cte AS
(SELECT *, ROW_NUMBER() OVER (PARTITION BY col1, col2, col3, col4 ORDER BY (SELECT 0)) AS DuplicateRowNumber
    FROM table
)
--SELECT * FROM cte WHERE DuplicateRowNumber > 1
DELETE FROM cte WHERE DuplicateRowNumber > 1

osmyn

private void HelpSetupActivitiesFakes(
            List<Activity> fakeActivity,
            ActivityOutcome fakeOutcome,
            List<ArgumentHierarchy> fakeHierarchy)
        {
            var mockedActivity = RepositoryTestingHelper
                .GetMockDbSet<Activity>(fakeActivity.AsQueryable());

            mockedActivity.Setup(x => x.Include("InputArgument"))
                .Returns(mockedActivity.Object);

osmyn

using System;
using Newtonsoft.Json;
using System.Collections.Generic;

namespace OneHundredCalories.Models
{
    [JsonObject]
    public class AlexaRequest
    {
        [JsonProperty("version")]

osmyn

using Newtonsoft.Json;
using Newtonsoft.Json.Serialization;
 
            var formatters = GlobalConfiguration.Configuration.Formatters;
            var jsonFormatter = formatters.JsonFormatter;
            var settings = jsonFormatter.SerializerSettings;
            settings.Formatting = Formatting.Indented;
            settings.ContractResolver = new CamelCasePropertyNamesContractResolver();

osmyn

var requestMessage = new HttpRequestMessage(HttpMethod.Get, "https://your.site.com");
requestMessage.Headers.Authorization = new AuthenticationHeaderValue("Bearer", your_token);
httpClient.SendAsync(requestMessage);

osmyn

public override int SaveChanges()
{
    var changed = ChangeTracker.Entries()
        .Where(e => e.State == EntityState.Modified || e.State == EntityState.Added);

    foreach (var item in changed)
    {
        if (item.Entity is IReadOnlyEntity)
        {
            item.State = EntityState.Unchanged;

osmyn

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