ASP.NET core, PostgreSQL

Related tags

Learning resource ASP.NET_citymobile_backend
Overview

Technologies

CityApp is built using the following technologies:

  • Visual Studio 2017
  • ASP.NET Core (Targeting .net 4.61)
  • SQL Server 2014/Azure SQL for data storage
  • Entity Framework Core for data access
  • Code First using Migrations
  • Dapper micro-ORM for report data access and for queries that EF can't handle easily
  • redis for caching
  • AWS S3 for file storage
  • Azure WebApps for hosting
  • Azure WebJobs for resource intensive background processing
  • Serilog for application logging
  • Bootstrap/Material UI Theme
  • SendGrid for transactional emails

Deploying

City App is hosted on Azure.

Data Context

Since this is a multitenant app with a physical database per tenant, we have 2 data contexts.

  • CommonContext is used for all things common to the application like User Authentication, LookUp Values, Account(Tenant) information and Database partitions
  • AccountContext is used for the application business requirement specific data, like Issues, Tickets, Vendors

Migration

How to create a migration in the common context

  • Add-Migration -Name [Name_of_your_Migration] -Context CityApp.Data.CommonContext

How to create a migration in account context

  • Add-Migration -Name [Name_of_your_Migration] -Context CityApp.Data.AccountContext
You might also like...

A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud

A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud.

Dec 15, 2022

Node.js TypeScript project demonstrating a Prisma integration with PostgreSQL

Prisma with PostgreSQL, TypeScript, Serverless and Parameter Store This project is the outcome of following the Prisma Getting Started guide. In addit

Aug 28, 2022

The Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, formatting, etc.

The Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, formatting, etc.

The Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, formatting, etc.

Jan 2, 2023

Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno

Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno

🚀 Fastest full-featured node & deno client 🏷 ES6 Tagged Template Strings at the core 🏄‍♀️ Simple surface API 🖊️ Dynamic query support 💬 Chat and

Jan 1, 2023

Here's a RESTful API that interacts with a PostgreSQL database written in NodeJS with Typescript, RESTify, and Sequelize ORM.

Here's a RESTful API that interacts with a PostgreSQL database written in NodeJS with Typescript, RESTify, and Sequelize ORM.

Basic description REST (Representational State Transfer) is a standard architecture for building and communicating with web services, It typically man

Jan 14, 2022

🐶 Puppies Rest Api built with NestJs, TypeOrm, PostgreSQL, Swagger

🚀 Quick start: Install node Install nest cli: `npm i -g @nestjs/cli` Initialize a nestjs project `nest new project-name` Swagger Docs swagger docs P

Oct 1, 2022

This is boilerplate of express, typescript and postgreSql with typeorm and docker based setup

express-typescript-postgres-typeorm-docker-swagger-boilerplate This is boilerplate of express, typescript and postgreSql with typeorm and docker based

Jun 2, 2022

🍉 Water is a micro-ORM + QueryBuilder designed to facilitate queries and operations on PostgreSQL databases designed to work in Melon

🍉 Water Water is a micro-ORM + QueryBuilder designed to facilitate queries and operations on PostgreSQL databases designed to work in MelonRuntime In

Aug 6, 2022

Deno + PostgreSQL = DenoGres

DenoGres Import Path: https://raw.githubusercontent.com/oslabs-beta/DenoGres/dev/mod.ts To install CLI: deno install --allow-read --allow-write --allo

Dec 29, 2022
Owner
Dredsoft
We Create Innovative & Powerful Software For Enterprise and SMBs
Dredsoft
GitHub
Using Htmx, ASP.NET Core, and Marten (postgres document db) to sort list

Using Htmx, ASP.NET Core, and Marten (postgres document db) to sort list

Khalid Abuhakmeh 5 Feb 16, 2022
The smallest CMS engine ever, made with ASP. NET Core and Dapper

TinyCMS The smallest CMS engine ever, made with ASP.NET Core and Dapper. Currently, only static content is supported, but adding new pages is as simpl

Marco Minerva 12 Dec 29, 2022
Create a C# .NET core EntityFramework ORM from your schema.prisma file

A note of forewarning to the would-be user... This was a failure. I'm making a note here: huge regret. It's hard to overstate my dissatisfaction. ?? S

Ian Ray 9 Dec 24, 2022
ITkonekt .NET workshop

Autobarn This is the sample application for Dylan Beattie's workshop on distributed systems with .NET. It's an Asp.NET Core web application based on v

Ursatile 1 Dec 19, 2021
Export Diagrams.net diagrams during Dendron site publishing

Export Diagrams.net diagrams during Dendron site publishing Node module for exporting Diagrams.net (Draw.io) diagrams embedded in a published Dendron

Luke Carrier 4 Aug 18, 2022
This template is for generating a .NET C# wrapper for the RabbitMQ client based on your AsyncAPI document.

.NET C# RabbitMQ template This is a .NET C# RabbitMQ template for the AsyncAPI generator This template is for generating a .NET C# wrapper for the Rab

AsyncAPI Initiative 5 Dec 21, 2022
CVTC Capstone Project - The Fish Net

The Fish Net Created By: Bruce Brown, Dave Oberlander, Mason Johnson, Timothy Harper About This is the repository for The Fish Net. It is a website to

David Oberlander 1 Nov 11, 2022
FCIV.NET is a open source strategy game loosely based on Freeciv

FCIV.NET FCIV.NET is an open-source turn-based strategy game. It can be played in any HTML5 capable web-browser and features in-depth game-play and a

FCIV.NET 13 Nov 22, 2022
Very simple full-stack application using React, Java Spring Boot, and PostgreSQL

Very simple full-stack application using React, Java Spring Boot, and PostgreSQL. The API was built following the N-Tier architecture. The goal was to explore and learn more in-depth the development of APIs, the use of Docker and deploying with AWS.

Diego Quintela 0 Apr 23, 2022
Smart-face-detector - A face detector application made with React JS, Node JS, Express JS, and PostgreSQL.

Getting Started with Create React App This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: np

Ken Tandrian 1 Sep 24, 2022