martinandersen3d

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

namespace System.Linq
{
    public static class QueryableHelper
    {
        public static IQueryable<TEntity> Search<TEntity>(this IQueryable<TEntity> query, string searchValue, params Expression<Func<TEntity, string>>[] propertiesToSearch)
        {
            if (string.IsNullOrEmpty(searchValue)) return query;

martinandersen3d

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Text.RegularExpressions;

/// <summary>
/// Provides methods for checking method arguments for validity and throwing localizable exceptions for invalid
/// arguments or argument combinations.

martinandersen3d

using System;
using System.Linq;
using System.Text;
using System.Collections.Generic;
using System.Globalization;

public static partial class StringExtensions
{
    public static sbyte ToSByte(this string s)
    {

martinandersen3d



using System;
using System.Linq;
using System.Text;
using System.Globalization;
namespace TextDataUtility
{
	public static partial class StringExtensions
	{

martinandersen3d

How to use Entity Framework Core with .Net Core Web Application

Packages

• Microsoft.EntityFrameworkCore
• Microsoft.EntityFrameworkCore.SqlServer - Only if MS SQL Server is used
• Microsoft.EntityFrameworkCore.Design
• Microsoft.EntityFrameworkCore.Tools

Code first

1. Create models

martinandersen3d

/*
    ORM (Object-Relational Mapping) allows us to have a framework
    for storing objects within relational databases and translating between
    DATABASE-CODE communication.

    What is ORM?
    1.  Object relational mapping is a technique for storing,
        retrieving, updating and deleting (CRUD) from
        an object-oriented program in a relational database.
    2.  Utilization of "data layer" to manage translation between the OO and relational

martinandersen3d

[TOC]

• Markdown
  • Emoji
  • Mermaid diagrams
  • Comment
  • H1
  • h2
  • H3
• H4

martinandersen3d

using System;
using System.Threading;

namespace MT.Tests
{
    /// <summary>
    /// An object containing some information.
    /// </summary>
    public class Logic
    {

martinandersen3d

using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc.Testing;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.DependencyInjection.Extensions;
using Tweetbook.Contracts.V1;
using Tweetbook.Contracts.V1.Requests;
using Tweetbook.Contracts.V1.Responses;

martinandersen3d

• Get VS Code
• Remove using NUnit.Framework;
• Add using XUnit;
• Replace all [Test] with [Fact]
• Replace [SetUp] with a constructor
• Replace Assert.That(actualValue, Is.EqualTo(value)); with Assert.Equal(expected, actual)
  • highlight Is.EqualTo(
  • Delete it
  • Select to the end of the line
• Ctrl + X