Skip to content

A small database first project which stores data from the Movie Database(TMDb) using JSON Data, SQL Server Management Studio and ASP.Net WinForms. JSON files are imported in SQL Server Database using T-SQL

Notifications You must be signed in to change notification settings

ThanosChristidis/FilmLibrary_JSON_SQL_ASP.NET_WebForms

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

FilmLibrary_JSON_SQL_ASP.NET_WinForms

The objective is to build a small project named MovieData. The application will use the API from The Movie DB (https://developers.themoviedb.org/3/getting-started), using an API key. The goal of this assignment is to implement an application or script that will retrieve and store movie information. The application must retrieve a list of the movies currently in theaters in Greece, along with at least the following attributes ● Title ● Description ● Original Title ● List of Directors ● The IMDB link to the profile of each of the directors

From https://api.themoviedb.org/3/discover/movie?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&region=GR&release_date.gte=2020-05-01&release_date.lte=2020-12-30&with_release_type=2|3, is the list of the movies which there are in greek theaters this period and I will use it in order to update Movie table. I assumed that the relationship between movies and directors is many to many for that reason I used the intermediate table MovieDirector.

I created an ASP.NET Web Application(.NET Framework) Web Forms Database First project. The database was connected with Asp.Net project implementing ADO.NET Entity Data Model

About

A small database first project which stores data from the Movie Database(TMDb) using JSON Data, SQL Server Management Studio and ASP.Net WinForms. JSON files are imported in SQL Server Database using T-SQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages