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
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • C# and OOP Programming
  • Entity Framework
  • Web Development
  • Basic Database Skills (querying, tables etc)
Description

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

Example

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
01:12:11
+
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
09:00

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
01:52

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
08:00

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
08:27

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
02:47

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
08:54

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
04:34

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
07:08

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
10:16
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