PostGreSQL with ASP.NET Core 1.0 (With An Extended Example)
4.3 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
27 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PostGreSQL with ASP.NET Core 1.0 (With An Extended Example) to your Wishlist.

Add to Wishlist

PostGreSQL with ASP.NET Core 1.0 (With An Extended Example)

Creating and building open source project using .NET framework. PostGre will rise up with a nice code design on .NET
4.3 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
27 students enrolled
Created by Can Perk
Last updated 7/2016
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Using PostGre
  • Using Web APIs
  • Using ASP.NET Core
View Curriculum
  • C# and OOP Programming
  • Entity Framework
  • Web Development
  • Basic Database Skills (querying, tables etc)

ASP.NET Core 1.0 is new trend of .NET developers. And some non-.NET developers will love this content too. 

PostGre SQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices.

Of course you need some other services. Are you tired of using WCF? It needs heavy configurations and hard to manage on some scenarios. Web API's will be with us to serve our methods.

Short Description:

We will use PostGre SQL to store data. A generic pattern will be make our project easier and we publish our project as web API. If we say directly the topic of this course : It is Open source development on .NET Framework


We will do a nice project example and It will not be a "Hello World" applicaition. I hope you will fill stars on the comments.

Lets's enjoy and learn the course

Who is the target audience?
  • Students and trainers should get at first
  • Software developers should take this course of course!!
  • People who want to learn about No-SQL with .NET
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
Getting Started
6 Lectures 22:05

Different titles are making me excited because of new things. Let's try new features about ASP.NET Core and some professional stuffs

Preview 02:35

What are the column types and what we should do when creating columns

Preview 02:15

It is time to create database to store our datas. Table design shold be serve to our code base. And we should define columns like defining class properties. 

Preview 02:13

You can download the script files to create you example easier. Before creating tables run sequences' script. First table is created for now but I will share the table script in next lecture

Preview 04:10

Table script can be downloaded to make your example better. I think you are repeting the example with lectrue and scripts can be usefull for now. As additional information, I changed a mistake in lecture and the new version is in the scripts. For example all Modified and Created columns have default values and they are set to current date

Creating Tables

On lessons, some dummy data helps you to test your project. You can download data scripts from this course

Adding Sample Data's and Using Queries

Let's test our knowledge for Section  "Getting Started"

Quiz 1
4 questions
Working With ASP.NET Core 1.0 on PostGre SQL
7 Lectures 50:06

Adding Class Library to reference and fix up some errors and understanding how ASP.NET Core works. Some base types are included under back yard project and started to created tables as entity classes in this lecture

What is ASP.NET Core 1.0 ? Creating The Project and Base Types

We completed entity classes and we will need a JSON helper to manages JSON data type on database. A little fix will save our project when we need to work with data. It is time to work with DataContext and connection

Creating Entities and Helpers

I decided to created JSON column types should be finished before creating contex. We just completed our extension methods to clearify JSON strings. I just used them

Fixing JSON Columns As Type Safe Properties

Our project is mixing of database first and code first. There is no code generator like T4 but we defined all classes. Then we should configure the context. We need a configuration file and some dependencies to work with PostGre SQL. Project is rising up and in next lecture UnitOfWork Pattern will be implemented.

Creating Context Base

Before accessing data, we need a strategy to manage it. We will learn how to create a repository base with UnitofWork pattern. 

Setting Up UnitOfWork and Generic Repository

A generic repository pattern applied in this lecture. We will write queries directly because of implementation IQueryable interface. And all CRUD operations are finished. 

Repository Class Design

After repository we will create UnitOfWork and I will be mplemented to DbContext. How will we access to repositories? Let's see the content.

UnitOfWork Class Design and Context
About the Instructor
Can Perk
4.7 Average rating
20 Reviews
100 Students
3 Courses
Software Developer & Consultant

Working on Microsoft technologies. 

I was graduated from University of Süleyman Demirel based on Computer and Controlling Education. During my work life I have been trainer on MCSD courses many times. 

Now working at BilgeAdam and Microsoft MCS consulting based on a project

I finished 2 Sharepoint Project on governements based on SharePoint. At the moment I am working on another big project based on WCF and WPF project