osmyn

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

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

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

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

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 

osmyn

       //ASYNC
       [TestMethod]
        public void GetTypesByName_WhenNoNameProvided_ThrowsArgumentException()
        {
            //Arrange
            var builder = new TypeServiceBuilder();
            var service = builder.Build();
            
            //Act
            Func<Task> call = async () => await service.GetTypesByName(null);

osmyn

        public Mock<IService> DefaultService()
        {
            var mock = new Mock<IService>();
            mock.Setup(x => x.MyMethod(It.IsAny<string>(), It.IsAny<string>(), It.IsAny<string>()))
                .Returns<string, string, string>((typeName, comments, updatedBy) => Task.Run(() =>
                    new MyType
                    {
                        TypeName = typeName,
                        Comments = comments,
                        UpdatedBy = updatedBy

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 BusinessLogic.Utilities.Interfaces;
using System;
using System.Collections.Generic;
using System.IO;
using System.IO.Compression;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using BusinessLogic.Logging;