# Meeting Minutes(22/08/20)

# Achievement

## Harry
discussed a template of ASP.NET core web app based on React in CRUD standards. The following is the template on Github. [OnlineBusiness on Github](https://github.com/harrykhlo/OnlineBusiness)

**Done:**
* ==CRUD functions==.
* Connected with local MS SQL server.
* React as View works nicely.

**Problem:**
* Wanted an individual and customlised View which is separated from .NET core module.
* Need to test how to connect to cloud-based SQL servers or a Code-first DB.
* NuGet has many plugins but checking and finding a suitable version is essential to avoid package version mismatch happening.

## Jack
discussed making connection with Azure SQL server and DB setting on Rider IDE. The following is the connection detail.

# ADO/ODBC/JDBC setting
connectString = "Server=tcp:ara-db-test.database.windows.net,1433; Initial Catalog=AraAzureDB;Persist Security Info=False;User ID=ara-admin;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

# Rider | Data source setting 
Server = ara-db-test.database.windows.net
port = 1433
Database = AraAzureDB
User = ara-admin
Password = Test1234

# .NET core project | Web.config
  <connectionStrings>
    <add name="SchoolContext"
         connectionString="metadata=res://*/;
         provider=System.Data.SqlClient;
         provider connection string=&quot;Data Source=tcp:ara-db-test.database.windows.net,1433; Initial Catalog=AraAzureDB; Persist Security Info=False; User ID=ara-admin; Password=Test1234; Encrypt=True; MultipleActiveResultSets=True;&quot;"
         providerName="System.Data.EntityClient"/>/>
  </connectionStrings>

**Done:**
* Creating an accessable Azure SQL DB & server.
* Run a .NET core template - ContosoUniversity

**Problem:**
* Cannot integrate Azure SQL DB and .NET core project. It seems the project needs some extra configurations(i.e. in Web.config file, connectionStrings parameter is needed).
* What is Entity Framework?

---
# Further Plans and Issues
- [ ] Which method we use to collect data, collecting data through API or using web crawler?
- [ ] Where do we put the data, local MSSQL, Azure cloud-based SQL server or other tech.
- [ ] A project design diagram/flow chart/mindmpa is considerably required. The following is an example.

- [ ] A list of what tools or techniques we use, and what are they used for.

---
# A temporary List of Tools or Techniques
format: [Name, Simple description]
* [**OnlineBusiness**, Our project on Github](https://github.com/harrykhlo/OnlineBusiness)
* [**Slack**, to share resource and communicate](https://join.slack.com/t/ara-friendship/shared_invite/zt-h3suqpkg-eDrs60mU2I9K4rQBC3HT4w )
* [**Azure**, cloud-based platform to test uploaded project](https://portal.azure.com/)
* [**Rider**, an IDE for coding C sharp](https://www.jetbrains.com/rider/)
* [**Trello**, project management tool to check process is ongoing](https://trello.com/en)
* [**Postman**, a platform for API development](https://www.postman.com/)
* [**Shared Google Drive**, to upload code demo or result](https://drive.google.com/drive/folders/1w5poZkl2Z-v5X8F8rHfVdIzikMjs8p2v?usp=sharing)
* **Front end language**: React or Vue
* **Backend language**: MS SQL, .NET Core
* **Web Crawler**: Python

---
# Resource
format: [Website, Title]
**Online Course**
1. [Lynda, Building React and ASP.NET MVC 5 Applications](https://www.lynda.com/ASP-NET-tutorials/Building-React-ASP-NET-MVC-5-Applications/751345-2.html)
2. [Microsoft, Virtual Training Days](https://www.microsoft.com/en-ca/sites/microsoft-training-days/azure.aspx)
3. [Python, Web Crawler Fundamental tutorial(Chinese)](https://drive.google.com/drive/folders/1Io8yX4F2p4TM4wdLD0O94EHefhcHawI3?usp=sharing)
4. [Coursera, Free cources for Uni. students](https://www.coursera.org/for-university-and-college-students?utm_source=link&utm_medium=share&utm_campaign=social_icons_freecourseraforstudents)

**Useful Reference**
1. [Microsoft, Tutorial: Create a web API with ASP.NET Core](https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-3.1&tabs=visual-studio)
2. [Microsoft, Quickstart: Use .NET Core (C#) to query a database in Azure SQL Database or Azure SQL Managed Instance](https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-core)