From 34136d9b019c1ddaf5d001c9701893ec8c62f8cf Mon Sep 17 00:00:00 2001
From: marcinzelent <marcin@zelent.net>
Date: Sun, 4 Jun 2017 19:11:37 +0200
Subject: Added local database file.

---
 ApartmentManager/HousingWebApi/App_Data/housingdb.mdf | Bin 0 -> 8388608 bytes
 .../HousingWebApi/App_Data/housingdb_log.ldf          | Bin 0 -> 8388608 bytes
 ApartmentManager/HousingWebApi/HousingWebApi.csproj   |  16 +++++++++-------
 ApartmentManager/HousingWebApi/Web.config             |   4 ++--
 4 files changed, 11 insertions(+), 9 deletions(-)
 create mode 100644 ApartmentManager/HousingWebApi/App_Data/housingdb.mdf
 create mode 100644 ApartmentManager/HousingWebApi/App_Data/housingdb_log.ldf

diff --git a/ApartmentManager/HousingWebApi/App_Data/housingdb.mdf b/ApartmentManager/HousingWebApi/App_Data/housingdb.mdf
new file mode 100644
index 0000000..6fb4146
Binary files /dev/null and b/ApartmentManager/HousingWebApi/App_Data/housingdb.mdf differ
diff --git a/ApartmentManager/HousingWebApi/App_Data/housingdb_log.ldf b/ApartmentManager/HousingWebApi/App_Data/housingdb_log.ldf
new file mode 100644
index 0000000..b33338f
Binary files /dev/null and b/ApartmentManager/HousingWebApi/App_Data/housingdb_log.ldf differ
diff --git a/ApartmentManager/HousingWebApi/HousingWebApi.csproj b/ApartmentManager/HousingWebApi/HousingWebApi.csproj
index b94fb4b..7ea765b 100644
--- a/ApartmentManager/HousingWebApi/HousingWebApi.csproj
+++ b/ApartmentManager/HousingWebApi/HousingWebApi.csproj
@@ -151,15 +151,15 @@
     </Reference>
   </ItemGroup>
   <ItemGroup>
-    <Compile Include="Controllers\ApartmentsController.cs" />
-    <Compile Include="Controllers\ChangeCommentsController.cs" />
-    <Compile Include="Controllers\ChangeDocumentsController.cs" />
-    <Compile Include="Controllers\ChangesController.cs" />
     <Compile Include="Models\Apartment.cs" />
     <Compile Include="Models\ApartmentResident.cs" />
     <Compile Include="Models\Change.cs" />
     <Compile Include="Models\ChangeComment.cs" />
     <Compile Include="Models\ChangeDocument.cs" />
+    <Compile Include="Controllers\ApartmentsController.cs" />
+    <Compile Include="Controllers\ChangeCommentsController.cs" />
+    <Compile Include="Controllers\ChangeDocumentsController.cs" />
+    <Compile Include="Controllers\ChangesController.cs" />
     <Compile Include="Controllers\DefectPicturesController.cs" />
     <Compile Include="App_Start\BundleConfig.cs" />
     <Compile Include="App_Start\FilterConfig.cs" />
@@ -212,6 +212,10 @@
     <Compile Include="Models\User.cs" />
   </ItemGroup>
   <ItemGroup>
+    <Content Include="App_Data\housingdb.mdf" />
+    <Content Include="App_Data\housingdb_log.ldf">
+      <DependentUpon>housingdb.mdf</DependentUpon>
+    </Content>
     <Content Include="Areas\HelpPage\HelpPage.css" />
     <Content Include="Content\bootstrap.css" />
     <Content Include="Content\bootstrap.min.css" />
@@ -265,9 +269,7 @@
     <Content Include="Views\Shared\Error.cshtml" />
     <Content Include="Views\Shared\_Layout.cshtml" />
   </ItemGroup>
-  <ItemGroup>
-    <Folder Include="App_Data\" />
-  </ItemGroup>
+  <ItemGroup />
   <ItemGroup>
     <Content Include="fonts\glyphicons-halflings-regular.woff" />
   </ItemGroup>
diff --git a/ApartmentManager/HousingWebApi/Web.config b/ApartmentManager/HousingWebApi/Web.config
index e610a4b..ce7b94a 100644
--- a/ApartmentManager/HousingWebApi/Web.config
+++ b/ApartmentManager/HousingWebApi/Web.config
@@ -80,6 +80,6 @@
     </providers>
   </entityFramework>
   <connectionStrings>
-    <add name="DataModel" connectionString="data source=(localdb)\MSSQLLocalDB;initial catalog=housingdb;integrated security=True;pooling=False;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
-  </connectionStrings>
+  <add name="DataModel" connectionString="data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\housingdb.mdf;integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
+</connectionStrings>
 </configuration>
\ No newline at end of file
-- 
cgit v1.2.3