<commit_before># EFGetStarted.ConsoleApp.NewDb

Here is a step-by-step rewrite of [original EF7 documentation example](http://ef.readthedocs.org/en/latest/getting-started/full-dotnet/new-db.html) built completely using [`generator-aspnet`](https://github.com/omnisharp/generator-aspnet) and SQLite for x-platform support. Any editor with OmniSharp support should provide syntax and tooling support.

Written using VSCode.

## Console Application to New Database

> In this walkthrough, you will build a console application that performs basic data access against a Microsoft SQL Server database using Entity Framework. You will use migrations to create the database from your model.

### Create a new project

```
yo aspnet

     _-----_
    |       |    .--------------------------.
    |--(o)--|    |      Welcome to the      |
   `---------´   |   marvellous ASP.NET 5   |
    ( _´U`_ )    |        generator!        |
    /___A___\    '--------------------------'
     |  ~  |     
   __'.___.'__   
 ´   `  |° ´ Y ` 

? What type of application do you want to create? 
  Empty Application 
❯ Console Application 
  Web Application 
  Web Application Basic [without Membership and Authorization] 
  Web API Application 
  Nancy ASP.NET Application 
  Class Library 
  Unit test project 

What's the name of your ASP.NET application? (ConsoleApplication) EFGetStarted.ConsoleApp.NewDb

cd EFGetStarted.ConsoleApp.NewDb/

dnu restore

dnx run
```

### Install Entity Framework

> To use EF7 you install the package for the database provider(s) you want to target. This walkthrough uses SQL Server. For a list of available providers see Database Providers.

```
dnu install EntityFramework.Sqlite
```

> Later in this walkthrough we will also be using some Entity Framework commands to maintain the database. So we will install the commands package as well.

```
dnu install EntityFramework.Commands
```
In the `project.json` commands add:
```
"ef": "EntityFramework.Commands"
```

Make sure to call:
```
dnu restore
```<commit_msg>Fix *newdb* documentation detail<commit_after># EFGetStarted.ConsoleApp.NewDb

Here is a step-by-step rewrite of [original EF7 documentation example](http://ef.readthedocs.org/en/latest/getting-started/full-dotnet/new-db.html) built completely using [`generator-aspnet`](https://github.com/omnisharp/generator-aspnet) and SQLite for x-platform support. Any editor with OmniSharp support should provide syntax and tooling support.

Written using VSCode.

## Console Application to New Database

> In this walkthrough, you will build a console application that performs basic data access against a Microsoft SQL Server database using Entity Framework. You will use migrations to create the database from your model.

### Create a new project

```
yo aspnet

     _-----_
    |       |    .--------------------------.
    |--(o)--|    |      Welcome to the      |
   `---------´   |   marvellous ASP.NET 5   |
    ( _´U`_ )    |        generator!        |
    /___A___\    '--------------------------'
     |  ~  |     
   __'.___.'__   
 ´   `  |° ´ Y ` 

? What type of application do you want to create? 
  Empty Application 
❯ Console Application 
  Web Application 
  Web Application Basic [without Membership and Authorization] 
  Web API Application 
  Nancy ASP.NET Application 
  Class Library 
  Unit test project 

What's the name of your ASP.NET application? (ConsoleApplication) EFGetStarted.ConsoleApp.NewDb

cd EFGetStarted.ConsoleApp.NewDb/

dnu restore

dnx run
```

### Install Entity Framework

> To use EF7 you install the package for the database provider(s) you want to target. This walkthrough uses SQL Server. For a list of available providers see Database Providers.

```
dnu install EntityFramework.Sqlite
```

> Later in this walkthrough we will also be using some Entity Framework commands to maintain the database. So we will install the commands package as well.

```
dnu install EntityFramework.Commands
dnu install EntityFramework.Sqlite.Design
```
In the `project.json` commands add:
```
"ef": "EntityFramework.Commands"
```

Make sure to call:
```
dnu restore
```
{'fraction_non_alphanumeric': 0.11388417736854858, 'fraction_numerical': 0.001453840562151684, 'mean_word_length': 2.973051010587103, 'pattern_counts': {'":': 2, '<': 3, '<?xml version=': 0, '>': 9, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '242304', 'n_tokens_mistral': 1200, 'n_tokens_neox': 1125, 'n_words': 448}