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.
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
Different titles are making me excited because of new things. Let's try new features about ASP.NET Core and some professional stuffs
What are the column types and what we should do when creating columns
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.
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
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
On lessons, some dummy data helps you to test your project. You can download data scripts from this course
Let's test our knowledge for Section "Getting Started"
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
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
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
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.
Before accessing data, we need a strategy to manage it. We will learn how to create a repository base with UnitofWork pattern.
A generic repository pattern applied in this lecture. We will write queries directly because of implementation IQueryable interface. And all CRUD operations are finished.
After repository we will create UnitOfWork and I will be mplemented to DbContext. How will we access to repositories? Let's see the content.
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