Home /dotnet

dotnet

Json serialize

using System;
using System.IO;
using System.Text.Json;
using System.Collections.Generic;

public class Program
{
public class MyModel
{
    public string MyString { get; set; }
    public int MyInt { get; set; }
    public bool MyBoolean { get; set; }
    public decimal MyDecimal { get; set; }
    public DateTime MyDateTime1 { get; set; }
    public DateTime MyDateTime2 { get; set; }
    public List<string> MyStringList { get; set; }
    public Dictionary<string, Person> MyDictionary { get; set; }
    public MyModel MyAnotherModel { get; set; }
}

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
}
public static void Main()
{
var options = new JsonSerializerOptions
{
    PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
    WriteIndented = true
};
Person p = new Person();
p.Id = 1;
p.Name = "HJH";
MyModel mm = new MyModel();
mm.MyInt = 1;
mm.MyBoolean = false;
mm.MyString = "string";

string s = JsonSerializer.Serialize(p, options);
Console.WriteLine(s);
string s2 = JsonSerializer.Serialize(mm, options);
Console.WriteLine(s2);
}
}

Tags: 
dotnet core
dotnet
.net

swagger

add package:
NSwag.AspNetCore

startup.cs

public void ConfigureServices(IServiceCollection services)
{
    services.AddControllers();
    services.AddOpenApiDocument();
}

Configure(IApplicationBuilder app, IWebHostEnvironment env)
...(after endpoints)...
app.UseOpenApi();
app.UseSwaggerUi3();

goto url localhost:5000/swagger

Tags: 
dotnet
.net
dotnetcore
swagger

dotnet core notes

localize date time
CultureInfo ci = new CultureInfo("nl-NL");Console.WriteLine(DateTime.Now.ToString("D", ci));

scaffold mysql db
dotnet ef dbcontext scaffold "server=localhost;port=3306;user=root;password=root;database=opit" MySql.Data.EntityFrameworkCore -o Models -f

Tags: 
dotnet
.net
scaffold
mysql

manual remove uninstall visual studio 2015

#!/bin/sh

# Uninstall Visual Studio for Mac
echo "Uninstalling Visual Studio for Mac..."

sudo rm -rf "/Applications/Visual Studio.app"
rm -rf ~/Library/Caches/VisualStudio
rm -rf ~/Library/Preferences/VisualStudio
rm -rf "~/Library/Preferences/Visual Studio"
rm -rf ~/Library/Logs/VisualStudio
rm -rf ~/Library/VisualStudio
rm -rf ~/Library/Preferences/Xamarin/
rm -rf ~/Library/Developer/Xamarin

# Uninstall Xamarin.Android
echo "Uninstalling Xamarin.Android..."

sudo rm -rf /Developer/MonoDroid
rm -rf ~/Library/MonoAndroid
sudo pkgutil --forget com.xamarin.android.pkg
sudo rm -rf /Library/Frameworks/Xamarin.Android.framework


# Uninstall Xamarin.iOS
echo "Uninstalling Xamarin.iOS..."

rm -rf ~/Library/MonoTouch
sudo rm -rf /Library/Frameworks/Xamarin.iOS.framework
sudo rm -rf /Developer/MonoTouch
sudo pkgutil --forget com.xamarin.monotouch.pkg
sudo pkgutil --forget com.xamarin.xamarin-ios-build-host.pkg


# Uninstall Xamarin.Mac
echo "Uninstalling Xamarin.Mac..."

sudo rm -rf /Library/Frameworks/Xamarin.Mac.framework
rm -rf ~/Library/Xamarin.Mac


# Uninstall Workbooks and Inspector
echo "Uninstalling Workbooks and Inspector..."

sudo /Library/Frameworks/Xamarin.Interactive.framework/Versions/Current/uninstall


# Uninstall the Visual Studio for Mac Installer
echo "Uninstalling the Visual Studio for Mac Installer..."

rm -rf ~/Library/Caches/XamarinInstaller/
rm -rf ~/Library/Caches/VisualStudioInstaller/
rm -rf ~/Library/Logs/XamarinInstaller/
rm -rf ~/Library/Logs/VisualStudioInstaller/

# Uninstall the Xamarin Profiler
echo "Uninstalling the Xamarin Profiler..."

sudo rm -rf "/Applications/Xamarin Profiler.app"

echo "Finished Uninstallation process."

Tags: 
.net
dotnet

double template code vs2015

change in solution file (.csproj)

    <ItemGroup>
        <None Remove="$(SpaRoot)**" />
        <None Include="$(SpaRoot)**" Exclude="$(SpaRoot)node_modules\**" />
    </ItemGroup>

Tags: 
.net
dotnet

MSSQL server with Docker

https://database.guide/how-to-install-sql-server-on-a-mac/

get docker container

sudo docker pull microsoft/mssql-server-linux:latest

create docker container
password needs
Uppercase letters, Lowercase letters, Base 10 digits, and Symbols..
docker run -e'ACCEPT_EULA=Y' -e'MSSQL_SA_PASSWORD=YourPassword123!' -p 1433:1433 --name sqlserver -d microsoft/mssql-server-linux

start docker container
docker exec -it sqlserver bash

run as SA
/opt/mssql-tools/bin/sqlcmd -U SA

view password (!)
echo $MSSQL_SA_PASSWORD

change password:
docker exec -it sqlserver2 /opt/mssql-tools/bin/sqlcmd -U SA'Root123!' -Q'ALTER LOGIN SA WITH PASSWORD="YourPassword123!"'

download
mssql datastudio

create and save data in volume

docker run -e'ACCEPT_EULA=Y' -e'MSSQL_SA_PASSWORD=YourPassword123!' -p 1433:1433 --name sqlserver2 -v sqlservervolume:/var/opt/mssql -d microsoft/mssql-server-linux

to see volumes
docker volume ls

backup external to local desktop...
docker cp newsqlserver:/var/opt/mssql ~/Desktop

copy into container
docker cp ~/Desktop/filetocopy.ext newsqlserver:/

backup from within the mssql in new backup folder
/opt/mssql-tools/bin/sqlcmd -U SA //get in db
1> BACKUP DATABASE Products TO DISK ='/var/opt/mssql/backup/Products.bak'
2> GO

exit
copy it to desired location...

code first approach:
dotnet ef migrations add InitialMigration
dotnet ef database update

sql operations studio:
no longer in active development...

azure datastudio:
same as sql operations studio...
https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql...

in azure datastudio:
new query

IF NOT EXISTS (
   SELECT name
   FROM sys.databases
   WHERE name = N'TutorialDB'
)
CREATE DATABASE [TutorialDB]
GO

ALTER DATABASE [TutorialDB] SET QUERY_STORE=ON
GO

Tags: 
docker
mssql
dotnet
.net

Dotnet core links

Dotnet Identity & mySQL

working identity with pomelo in dotnet 2.1

Nice article dotnet core 2 with link sql creation file

identity proj

implementing Identity storage provider

UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root'; 

or

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

docker exec -i mysql-server mysql -uroot -p"root" mysql < orkestpit.sql

with homebew:

brew tap homebrew/services
brew services list
brew install mysql@5.7
brew services start mysql
mysql_secure_installation

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile
source ~/.bash_profile
mysql -V
Tags: 
mvc
.net
#c
dotnetcore
dotnet
mysql
Subscribe to RSS - dotnet