msallin · msallin · Apr 4, 2015 · Apr 4, 2015 · Apr 4, 2015 · Apr 4, 2015
diff --git a/README.md b/README.md
@@ -1,4 +1,8 @@
 # SQLite CodeFirst
+**Release Build** [![Build status](https://ci.appveyor.com/api/projects/status/2qavdqctw0ehscm6/branch/master?svg=true)](https://ci.appveyor.com/project/msallin/sqlitecodefirst-nv6vn/branch/master)
+
+**CI Build** [![Build status](https://ci.appveyor.com/api/projects/status/oc1miog385h801qe?svg=true)](https://ci.appveyor.com/project/msallin/sqlitecodefirst)
+
 Creates a [SQLite Database](https://sqlite.org/) from Code, using [Entity Framework](https://msdn.microsoft.com/en-us/data/ef.aspx) CodeFirst.
 
 This Project ships several `IDbInitializer` which creates a new SQLite Database, based on your model/code.

diff --git a/SQLite.CodeFirst.Console/Properties/AssemblyInfo.cs b/SQLite.CodeFirst.Console/Properties/AssemblyInfo.cs
@@ -1,18 +1,10 @@
 using System.Reflection;
-using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
-// General Information about an assembly is controlled through the following 
-// set of attributes. Change these attribute values to modify the information
-// associated with an assembly.
-[assembly: AssemblyTitle("SQLite.CodeFirst.Console")]
-[assembly: AssemblyDescription("")]
-[assembly: AssemblyConfiguration("")]
-[assembly: AssemblyCompany("")]
+[assembly: AssemblyTitle("SQLite.CodeFirst")]
+[assembly: AssemblyDescription("A console application which demonstrates how to use QLite.CodeFirst.")]
 [assembly: AssemblyProduct("SQLite.CodeFirst")]
-[assembly: AssemblyCopyright("Copyright ©  2015")]
-[assembly: AssemblyTrademark("")]
-[assembly: AssemblyCulture("")]
+[assembly: AssemblyCopyright("Copyright © Marc Sallin")]
 
 // Setting ComVisible to false makes the types in this assembly not visible 
 // to COM components.  If you need to access a type in this assembly from 
@@ -22,15 +14,6 @@
 // The following GUID is for the ID of the typelib if this project is exposed to COM
 [assembly: Guid("945f6a68-1bcd-47ff-a551-a2820b88ff8c")]
 
-// Version information for an assembly consists of the following four values:
-//
-//      Major Version
-//      Minor Version 
-//      Build Number
-//      Revision
-//
-// You can specify all the values or you can default the Build and Revision Numbers 
-// by using the '*' as shown below:
-// [assembly: AssemblyVersion("1.0.*")]
 [assembly: AssemblyVersion("1.0.0.0")]
 [assembly: AssemblyFileVersion("1.0.0.0")]
+[assembly: AssemblyInformationalVersion("1.0.0.0")]
diff --git a/SQLite.CodeFirst.sln b/SQLite.CodeFirst.sln
@@ -14,6 +14,11 @@ Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = ".nuget", ".nuget", "{01B97A
 		.nuget\NuGet.targets = .nuget\NuGet.targets
 	EndProjectSection
 EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Build", "Build", "{7031BD3C-AE76-43CD-91B6-B6BCD823968C}"
+	ProjectSection(SolutionItems) = preProject
+		release_appveyor.yml = release_appveyor.yml
+	EndProjectSection
+EndProject
 Global
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
 		Debug|Any CPU = Debug|Any CPU

diff --git a/SQLite.CodeFirst/Properties/AssemblyInfo.cs b/SQLite.CodeFirst/Properties/AssemblyInfo.cs
@@ -1,18 +1,14 @@
 using System.Reflection;
-using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
-// General Information about an assembly is controlled through the following 
-// set of attributes. Change these attribute values to modify the information
-// associated with an assembly.
 [assembly: AssemblyTitle("SQLite.CodeFirst")]
-[assembly: AssemblyDescription("")]
-[assembly: AssemblyConfiguration("")]
-[assembly: AssemblyCompany("")]
+[assembly: AssemblyDescription(
+    "Creates a SQLite Database from Code, using Entity Framework CodeFirst. " +
+    "This Project ships several IDbInitializer which creates " +
+    "a new SQLite Database, based on your model/code.")]
 [assembly: AssemblyProduct("SQLite.CodeFirst")]
-[assembly: AssemblyCopyright("Copyright ©  2015")]
-[assembly: AssemblyTrademark("")]
-[assembly: AssemblyCulture("")]
+[assembly: AssemblyCopyright("Copyright © Marc Sallin")]
+[assembly: AssemblyCompany("Marc Sallin")]
 
 // Setting ComVisible to false makes the types in this assembly not visible 
 // to COM components.  If you need to access a type in this assembly from 
@@ -22,15 +18,7 @@
 // The following GUID is for the ID of the typelib if this project is exposed to COM
 [assembly: Guid("46603902-448a-4c50-87ec-09cb792b740f")]
 
-// Version information for an assembly consists of the following four values:
-//
-//      Major Version
-//      Minor Version 
-//      Build Number
-//      Revision
-//
-// You can specify all the values or you can default the Build and Revision Numbers 
-// by using the '*' as shown below:
-// [assembly: AssemblyVersion("1.0.*")]
+// Will be replaced by the build server
 [assembly: AssemblyVersion("1.0.0.0")]
 [assembly: AssemblyFileVersion("1.0.0.0")]
+[assembly: AssemblyInformationalVersion("1.0.0.0")]
diff --git a/SQLite.CodeFirst/SQLite.CodeFirst.csproj b/SQLite.CodeFirst/SQLite.CodeFirst.csproj
@@ -46,7 +46,6 @@
     <Reference Include="System" />
     <Reference Include="System.Core" />
     <Reference Include="System.Data" />
-    <Reference Include="System.Data.Entity" />
   </ItemGroup>
   <ItemGroup>
     <Compile Include="Builder\ColumnStatementCollectionBuilder.cs" />
@@ -75,6 +74,7 @@
   </ItemGroup>
   <ItemGroup>
     <None Include="packages.config" />
+    <None Include="SQLite.CodeFirst.csproj.nuspec" />
   </ItemGroup>
   <ItemGroup />
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

diff --git a/SQLite.CodeFirst/SQLite.CodeFirst.csproj.nuspec b/SQLite.CodeFirst/SQLite.CodeFirst.csproj.nuspec
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd">
+  <metadata>
+    <id>$id$</id>
+    <version>$version$</version>
+    <authors>$author$</authors>
+    <owners>$author$</owners>
+    <licenseUrl>https://github.com/msallin/SQLiteCodeFirst/blob/master/LICENSE</licenseUrl>
+    <projectUrl>https://github.com/msallin/SQLiteCodeFirst</projectUrl>
+    <requireLicenseAcceptance>false</requireLicenseAcceptance>
+    <description>$description$</description>
+    <summary>Creates a SQLite Database from Code, using Entity Framework CodeFirst.</summary>
+    <releaseNotes />
+    <copyright>Copyright (C) Marc Sallin</copyright>
+    <tags>SQLite EntityFramework EF CodeFirst</tags>
+    <dependencies>
+      <dependency id="EntityFramework" version="6.1" />
+    </dependencies>
+    <frameworkAssemblies>
+      <frameworkAssembly assemblyName="System" targetFramework="" />
+      <frameworkAssembly assemblyName="System.Core" targetFramework="" />
+      <frameworkAssembly assemblyName="System.Data" targetFramework="" />
+    </frameworkAssemblies>
+  </metadata>
+  <files>
+    <file src="bin\$configuration$\$id$.dll" target="lib\net45\SQLite.CodeFirst.dll" />
+  </files>
+</package>
diff --git a/release_appveyor.yml b/release_appveyor.yml
@@ -0,0 +1,48 @@
+# See http://www.appveyor.com/docs/appveyor-yml for many more options
+
+version: Release_{branch}_0.9.{build}.0
+branches:
+  only:
+  - master
+skip_tags: true
+# Skip on updates to the readme.
+# We can force this by adding [skip ci] or [ci skip] anywhere in commit message
+skip_commits:
+  message: /Update (README.md|LICENSE|.gitignore|.gitattributes)*/ 
+configuration: Release
+platform: Any CPU
+assembly_info:
+  patch: true
+  file: '**\AssemblyInfo.*'
+  assembly_version: 0.9.{build}.0
+  assembly_file_version: 0.9.{build}.0
+  assembly_informational_version: 0.9.{build}.0
+build:
+  publish_nuget: true
+  publish_nuget_symbols: true
+  verbosity: normal
+artifacts:
+- path: SQLite.CodeFirst\bin\*\SQLite.CodeFirst.dll
+  name: SQLiteCodeFirst
+deploy:
+- provider: NuGet
+  api_key:
+    secure: QmbFnerlfTAFUZpnaPgVDywMH4fF8rVakefmqvhu3qm9SpuDlLGB9S4HwtdE3Nep
+  on:
+    branch: master
+- provider: GitHub
+  tag: v$(appveyor_build_version)
+  release: v$(appveyor_build_version)
+  description: https://www.nuget.org/packages/SQLite.CodeFirst/
+  auth_token:
+    secure: e3cqaFy9PzI9TAdZJBIDy97Bfbwa7j0EXe2yw7Ev9aJXK0Q+3mnULqb1VU4P7BWR
+  artifact: SQLiteCodeFirst
+  draft: true
+  on:
+    branch: master
+notifications:
+- provider: Webhook
+  url: https://zapier.com/hooks/catch/b3cbz0/
+  on_build_success: true
+  on_build_failure: true
+  on_build_status_changed: false