sudo apt-get install wget unzip
sudo apt-get install libaio1 libtinfo5

sudo add-apt-repository ppa:swi-prolog/stable
sudo apt-get update
sudo apt-get install swi-prolog-nox=7.\*

cd $HOME
mkdir Starcounter.3.0.0-rc-20191212
cd Starcounter.3.0.0-rc-20191212
wget https://starcounter.io/Starcounter/Starcounter.3.0.0-rc-20191212.zip
unzip Starcounter.3.0.0-rc-20191212.zip

mkdir StarcounterConsoleSample
cd StarcounterConsoleSample
​
dotnet new console

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <packageSources>
    <clear />
    <add key="local" value="[Starcounter.3.0.0-rc-20191212]" />
    <add key="Starcounter" value="https://www.myget.org/F/starcounter/api/v2" />
    <add key="nuget.org" value="https://api.nuget.org/v3/index.json" />
  </packageSources>
</configuration>

dotnet add package Starcounter.Database --version 3.0.0-*

using System;
using System.Linq;
using Starcounter.Database;
using Microsoft.Extensions.DependencyInjection;
​
namespace StarcounterConsoleSample
{
    [Database]
    public abstract class Person
    {
        public abstract string Name { get; set; }
    }
​
    public class Program
    {
        public static void Main()
        {
            string connectionString =
                "Database=./.database/StarcounterConsoleSample;"
                + "OpenMode=CreateIfNotExists;"
                + "StartMode=StartIfNotRunning;"
                + "StopMode=IfWeStarted";
​
            // Here we create a service collection that
            // we add the Starcounter services to.
            // When we call BuildServiceProvider(), we get an instance
            // that we can use to fetch service instances,
            // for example ITransactor, which we then can use to
            // to make database transactions.
            using var services = new ServiceCollection()
                .AddStarcounter(connectionString)
                .BuildServiceProvider();
​
            // Here we fetch our ITransactor instance from the service provider.
            var transactor = services.GetRequiredService<ITransactor>();
​
            // And here we use it to make a database transaction.
            var name = transactor.Transact(db =>
            {
                // Here inside the transaction,
                // we can use the IDatabaseContext instance
                // to interact with the Starcounter database.
​
                // We can query it using SQL
                // (which returns an IEnumerable<Person>
                // that we can use with LINQ).
                var p = db.Sql<Person>
                (
                    "SELECT p FROM Person p WHERE Name = ?",
                    "Jane"
                ).FirstOrDefault();
​
                if (p == null)
                {
                    // We can insert new rows in the database using Insert().
                    p = db.Insert<Person>();
​
                    // We write to the database row
                    // using standard C# property accessors.
                    p.Name = "Jane";
                }
​
                // Let's return the name as result of the transaction.
                return p.Name;
            });
​
            // And let's print it in the console
            Console.WriteLine(name);
        }
    }
}

using Microsoft.AspNetCore.Builder;
using Microsoft.Extensions.DependencyInjection;
​
namespace StarcounterMvcSample
{
    public class Startup
    {
        public void ConfigureServices(IServiceCollection services)
        {
            string connectionString =
                "Database=./.database/StarcounterMvcSample;"
                + "OpenMode=CreateIfNotExists;"
                + "StartMode=StartIfNotRunning;"
                + "StopMode=IfWeStarted";
​
            // This adds and configures Starcounter services to our application,
            // for example ITransactor,
            // that allows us to create database transactions.
            services.AddStarcounter(connectionString);
        }
    }
}