IT:AD:Code First:HowTo:Get Started [Notes]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

# IT:AD:Code First:HowTo:Get Started #

<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


<panel title="Summary">



</panel>


## Process ##

* In Visual Studio...
* In a new Console Project...
* As per ((https://docs.microsoft.com/en-us/aspnet/web-api/overview/hosting-aspnet-web-api/use-owin-to-self-host-web-api)):
* `Install-Package Microsoft.AspNet.WebApi.OwinSelfHost`
* and create the routing.
* Test it before getting on to the db site.
* `Install-Package EntityFramework` or `Install-Package EntityFramework.SqlServerCompact`
  * Accept the licenses...
  * May require a restart if it is the first time you've installed EF.
* Back in Visual Studio... 
* Create a SqlServer CE connection string.

<sxh xml>
<configuration>
  <connectionStrings>
    <add name="FooProjectDbCN"
         providerName="System.Data.SqlServerCe.4.0"
         connectionString="Data Source=|DataDirectory|\Data\FooProjectDb.sdf"/>
  </connectionStrings>
</configuration>
</sxh>