martinandersen3d

#!markdown

# Using SQLite in Notebook

Install ExtensionLab NuGet package

#!csharp

#r "nuget: System.Data.SQLite, *-*"
#r "nuget: Microsoft.DotNet.Interactive.ExtensionLab, *-*"

martinandersen3d

#!markdown

Records in C#

#!csharp

public class Course
{
    public string Name {get; set;}
    public string Author {get; set;}

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
    {