Day 16 - 2 - Complete Storing Instance and Scriptable Object Data on SQL Server - Unity3d + Asp.NET

In this video, we complete adding records to the SQL server for every gameobject instance created as well as linking it to a SQL server record representing a scriptable object. This work is completed in anticipation of the multiplayer implementation.

Gem Wars is a game created in Unity3d with an Asp.NET Core 3.1 WebAPI backend using REST as the data-transfer protocol. The game is 2D and all assets were created in the first videos of the series. The backend server is using MS SQL server hosted through Amazon Web Services (AWS) and Entity Framework as the data-access layer (DAL) / object relational model (ORM). All services and applications are hosted on scalable micro-services through Docker and AWS Elastic Container Service (ECS). We are also using an IdentityServer4 for the authorization server with a custom grant handler for Google connections through Unity.

Gem Wars is a block-tile game where the goal is to form lines either vertically or horizontally. Completed lines will disappear, and the player will accrue a number of points for the number and tier of tiles in the line, the number of lines, and a multiplier that grows for the number of gems and gem tier in the line. Gem Wars has 3 game modes - Free Play, Practice Vs AI, and Battle. In Battle, 8 players are entered into a ladder and compete 1v1 for the highest score in individual matches. Each player begins with 10 health, and each loss results in a reduction of health by 1. The game completes when 1 player remains and reigns champion of the ladder. Practice Vs AI is a game-mode for practicing for Battle and is a single Match between you and an AI player. The AI is real-time on the same board as the player, and as more lines are created, the AI speed increases. Finally, Free Play is a game mode where players create as many lines as possible and try to achieve the highest score they can on the leaderboard.

GemWars is available as a free demo at https://www.pixelhorrorstudios.com, and will be released formally on Android Play Store and iOS store. All content and programming occurred live on Twitch.tv at https://www.twitch.tv/liveordevtrying. If there are any questions regarding the design, programming practices, or asset critique, please comment here or join the active Discord at https://discord.pixelhorrorstudios.com.