- Microsoft.EntityFrameworkCore
- Microsoft.EntityFrameworkCore.SqlServer - Only if MS SQL Server is used
- Microsoft.EntityFrameworkCore.Design
- Microsoft.EntityFrameworkCore.Tools
- Create models
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>Bootstrap all elements</title> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> | |
| <meta http-equiv="X-UA-Compatible" content="IE=edge" /> | |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous"> |
| #!csharp | |
| using System.Collections.Generic; | |
| using System.Linq; | |
| using Microsoft.DotNet.Interactive; | |
| using Microsoft.DotNet.Interactive.Formatting; | |
| using static Microsoft.DotNet.Interactive.Formatting.PocketViewTags; | |
| void downloadAndShowImages(params string[] urls) { | |
| display(span(urls.Select(url => |
| #!markdown | |
| # Using SQLite in Notebook | |
| Install ExtensionLab NuGet package | |
| #!csharp | |
| #r "nuget: System.Data.SQLite, *-*" | |
| #r "nuget: Microsoft.DotNet.Interactive.ExtensionLab, *-*" |
| #!markdown | |
| Records in C# | |
| #!csharp | |
| public class Course | |
| { | |
| public string Name {get; set;} | |
| public string Author {get; set;} |
| 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; |
| 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. |
| 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) | |
| { |
| | |
| using System; | |
| using System.Linq; | |
| using System.Text; | |
| using System.Globalization; | |
| namespace TextDataUtility | |
| { | |
| public static partial class StringExtensions | |
| { |
| /* | |
| 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 |