DotNetJalps

A minimal web application structure with technologies like node.js, typescript, express

noreply@blogger.com (Jalpesh Vadgama) — Sat, 5 May 2018 13:58:00 +0530

Recently, I have been working the lot with Node.js and TypeScript. And I absolutely love TypeScript due to its features. I was actually looking for a boilerplate code to start which should be very easy to understand. But there was no code there. So I decided to create a minimum web application structure. I have used it in some project and I was quite happy with it.

So I thought why should I make it open source so that people can also get benefited by this. So here I am presenting A minimal Web Application Structure with technologies like Node.js, TypeScript, and Express.

You can find the complete source code on Github at following location - https://github.com/dotnetjalps/minimum-nodejs-typescript-express

How to Run this Project:

To run this project you need to first install all the NPM packages via the following command.

npm install

Then you can run this project with the following command.

npm start

Directory Structure Of Project:

App.ts – Typescript file for creating express application class and where we have initialized the application.
routes.ts - Typescript files for creating all the routes under Init() Method.
package.json - Contains all the packages and dev dependencies required for this application. You can add more as your requirement.
tsconfig.json - Where all the typescript configuration is there and we converting typescript into ES5.
Controller Folder - Contains all the classes for the controller of the express application
tsconfig.josn - Contains all the rules for TypeScript linting.

I’m looking for constructive feedback on this and I’m hoping that I will get it.

Flexible Object Mapping in Entity Framework Core 2.0

noreply@blogger.com (Jalpesh Vadgama) — Fri, 27 Apr 2018 06:29:00 +0530

Entity Framework 2.0 is out for some time. If you don’t know Entity Framework 2.0 is a lightweight, extensible and Cross-Platform Object-relational mapper from Microsoft. It is a new version of Entity Framework which is now cross-platform and can now run now operating system like Linux, Mac etc.With Entity Framework Core 2.0, There are tons of ways to create a table and we are going to see one of that. In this blog post, We are going to see how we are going to see how we can create a field for private fields in the table.

So what we are waiting for. Let’s get started.

Flexible Object Mapping in Entity Framework Core 2.0:

So in this example, We are going to create a Console Application like following.

Once we are done with Creating Application We are going to insert NuGet Package for EF Core like below.

You can also install it via running following command.

Install-Package Microsoft.EntityFrameworkCore -Version 2.0.2

Here we are going to install SQL Server Express as a database so we need to install Nuget Package for that also.

You can also install via running following command.

Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 2.0.2

Now it’s time to write some code. First of all, We are going to create A model called Student and In that, we are going to have two private fields.

namespace EFCore2Mapping
{
    public class Student
    {

        public int StudentId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }


        private string _standard;
        private string _division;


        public void AssignStandard(string standard)
        {
            _standard = standard;
        }

        public void AssignDivision(string division)
        {
            _division = division;
        }

        public string GetStandard()
        {
            return _standard;
        }

        public string GetDivision()
        {
            return _division;
        }
    }
}

Here in the above code, You have seen that I have created few fields for Student Model. If you see it carefully, You can see that there are two private fields _standard and _division. And there are two methods for each field to get and set private variables.

Now let’s write our Entity Framework Data Context. That’s where the Magic going to happen.

using Microsoft.EntityFrameworkCore;

namespace EFCore2Mapping
{
    public class StudentContext : DbContext
    {
        public DbSet<Student> Student { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer("Data Source=Your Server;Initial Catalog=Student;User ID=sa;Password=Jalpesh@123");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Student>().Property<string>("Division").HasField("_division");
            modelBuilder.Entity<Student>().Property<string>("Standard").HasField("_standard");
        }
    }
}

Here in the above code, If you see I have created a dataset for our student model that is a standard way to create a table for the map. There is another method OnCofiguring for giving database connection string. There are is another method called OnModelCreating which Entity framework core uses to create tables. Here If you see that I have written code to map private fields to Table Fields so that two fields Division and Standard will be created with tables.

Now let’s run the migration to create a table like following.

You need to go to the Nuget Package Manager Console and then run the following command.

Add Migration Initial Create

Once you are done with it. It will create the tables in the database like following.

Now let’s write some code insert data in the table. So following is code for the same.

using System;
using System.Collections.Generic;
using System.Linq;

namespace EFCore2Mapping
{
    class Program
    {
        static void Main(string[] args)
        {

            List<Student> ExistingStudents = new List<Student>();

            Student student = new Student
            {
                FirstName = "Joe",
                LastName = "Tailor",
            };
            student.AssignStandard("5");
            student.AssignDivision("A");

            using (StudentContext studentConext = new StudentContext())
            {
                ///Adding a new Student;
                studentConext.Student.Add(student);
                studentConext.SaveChanges();


                ///Retriviting newly added student
                ExistingStudents = studentConext.Student.ToList();
                
            }

            foreach(Student s in ExistingStudents)
            {
                Console.WriteLine($"Student Id: {s.StudentId}");
                Console.WriteLine($"First Name: {s.FirstName}");
                Console.WriteLine($"Last Name:{s.LastName}");
                Console.WriteLine($"Standard:{s.GetStandard()}");
                Console.WriteLine($"Division:{s.GetDivision()}");
            }
        }
    }
}

Here you can see that in the above code, I have created Student called Joe Tailor and then I have saved it in the database and then I have written the code for fetching the student data and print it via for loop.

When you run this application It will show like following.

That’s it. Here you can see that It’s very easy to Manipulate the Columns with Entity Framework core 2.0. Hope you like it.

This complete blog post source code available on github at - https://github.com/dotnetjalps/EFCoreFlexibleObjectMapping

Register for Global Azure Bootcamp 2018–from Ahmedabad User Group

noreply@blogger.com (Jalpesh Vadgama) — Sat, 7 Apr 2018 11:04:00 +0530

Friends, We are back with new events again. We are going to host Global Azure Bootcamp 2018.

About Global Azure Bootcamp:

If you don’t know what is Global Azure Bootcamp then it is a worldwide Event for Azure. All around the world user groups and communities want to learn about Azure and Cloud Computing!

On April 21, 2018, all communities will come together once again in the sixth great Global Azure Bootcamp event! Each user group will organize their own one-day deep dive class on Azure the way they see fit and how it works for their members. The result is that thousands of people get to learn about Azure and join together online under the social hashtag #GlobalAzure!

Ahmedabad User Group is also organizing the same. This time we want to put it on a bigger level. So there will be lots more to learn, A great opportunity to network with like-minded people. Best Part you will get a chance to meet lots of awesome speakers. It has also got lunch included!.

I am also one of the speakers and will be presenting About Azure Active Directory.

So what you are waiting for go Grab a chance to meet and learn about Azure Cloud Platform.
Here is a link from where you can register for Global Azure Bootcamp 2018.

https://www.eventbrite.com/e/global-azure-bootcamp-2018-by-ahmedabadusergroup-tickets-40757803688

I am hoping to see you everybody there!!. Go Grab before it gets full!.

Video Recording : Webinar on ASP.NET Core on Linux

noreply@blogger.com (Jalpesh Vadgama) — Sat, 7 Apr 2018 10:20:00 +0530

I have done a Webinar for DotNetTricks.com about ASP.NET Core on Linux. There were lots of curiosity about it and lots of people asked for the recording of Webinar so here we go Following is a link of recording of Webinar for ASP.NET Core on Linux. You can watch the full webinar on youtube at following.

https://www.youtube.com/watch?v=Hf0F7nZCTXM&t=706s

I would also like to Thanks Shailendra and Whole DotNetTricks team for the having me on this webinar.

Thank you. Stay tuned there were lots of stuff coming from ASP.NET core and Node.js.

Solution: (Error)Unable to Correct problems, You have held broken packages–Install .NET Core on Ubuntu

noreply@blogger.com (Jalpesh Vadgama) — Sat, 10 Mar 2018 14:32:00 +0530

Recently, I have been using Linux(Ubuntu) machine on my virtual box quite a bit and as Microsoft.NET Developer I want to install .NET Core on Ubuntu. So I tried following the instruction from below link to install .NET core on Ubuntu 16.04.

https://docs.microsoft.com/en-us/dotnet/core/linux-prerequisites?tabs=netcore2x

But I was not unable to install .NET Core and I was getting following errors.

The following packages have unmet dependencies:
dotnet-sdk-2.1.4 : Depends: dotnet-runtime-2.0.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

You can see the same error in the following screenshot.

I was a little bit curious about that and then I have read carefully the documentation mentioned on the above link and I have found that .NET Core require following require following Ubuntu distributions as Prerequisites.

libunwind8
liblttng-ust0
libcurl3
libssl1.0.0
libuuid1
libkrb5-3
zlib1g
libicu52 (for 14.X)
libicu55 (for 16.X)
libicu57 (for 17.X)

Most of the time it should be installed by default with sudo apt-get update and sudo apt-get upgrade command but sometimes it does not. So what I did install all these distributions one by one via sudo apt-get install command and in my case, I was not having liblttng-ust0 distribution on my machine. So I have installed it via the following command.

sudo apt-get install liblttng-ust0

You can also see below screenshot for the same.

Then I was able to install .NET Core on my machine via following above link on documentation.

And now it’s running .NET Core v 2.1.4 on my Ubuntu VirtualBox as you can see it in below dotnet version command.

I was able to solve my problem this and so I thought it will be a good idea to share it on my blog so it will help people who are having the same problem.

Stay tuned for more there is a lot more coming for asp.net core and node.js on Linux on future blog posts.

How to install Robo3T(Formerly RobMongo) on Ubuntu

noreply@blogger.com (Jalpesh Vadgama) — Sat, 10 Mar 2018 12:48:00 +0530

Robo3T formerly known as RobMongo is one of best GUI tools for the managing and querying MongoDB database. I have been using it quite often for creating applications with MongoDB and Node.js. Recently a new version made available but there were no instructions for installing it on Ubuntu. So I thought it would be a great idea to write a blog post about it.

To install it. First, we need to open terminal and download tar.gz file from official site with the following command.

wget https://download.robomongo.org/1.2.1/linux/robo3t-1.2.1-linux-x86_64-3e50a65.tar.gz

Once download will complete we need to extract tar.gz file with following command

tar -xvzf robo3t-1.2.1-linux-x86_64-3e50a65.tar.gz

As now we have extract it into the folder we need to move that under /usr/local/bin directory to make it available for all the users. So todo that we need to first create robo3t directly under /usr/local/bin folder with following command.

sudo mkdir /usr/local/bin/robo3t

Then we need to move all the files of extracted folder into robo3t folder under /usr/local/bin directory with following command.

sudo mv  robo3t-1.2.1-linux-x86_64-3e50a65/* /usr/local/bin/robo3t

Now, We need to give permission to newly created directory with following command.

sudo chmod +x robo3t ./robo3t

Once you are done with it. You are ready to use robo3t. You can run it from command line from usr/local/bin directory via following command.

./robo3t

And it will run the Robo3t like following.

That’s it. Hope you like, Stay tuned for more!!.

How to install Visual Studio code on Ubuntu

noreply@blogger.com (Jalpesh Vadgama) — Wed, 7 Mar 2018 20:46:00 +0530

Recently I presented a Webinar on ASP.NET Core on Linux. Here I have displayed how we can use Visual Studio Code a Free Open Source Editor from Microsoft to develop application. One of frequently ask question was How I can install Visual Studio Code on Linux. Since lots of People are using Ubuntu as Development Machine I thought it will be a good idea to write a blog post about how to install Visual Studio code on Linux(Ubuntu Machine).

So first thing we need to do it open a terminal in Ubuntu and then we need to type following command one by one.

curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > microsoft.gpg

Then you need to run the following command to move gpg file download via Curl to etc/apt folder.

sudo mv microsoft.gpg /etc/apt/trusted.gpg.d/microsoft.gpg

Now, You need to run following command.

sudo sh -c 'echo "deb [arch=amd64] https://packages.microsoft.com/repos/vscode stable main" > /etc/apt/sources.list.d/vscode.list'

After that, you need to run Apt-get Command to update package cache and Apt-get install command to install visual studio code.

sudo apt-get update
sudo apt-get install code

That’s it. You are done with installing Visual Studio Code. You can find more information about different Linux flavors at following link on Visual Studio code.

https://code.visualstudio.com/docs/setup/linux

Hope you like it. Stay tuned for more!!

How to install node.js and npm on Debian 9

noreply@blogger.com (Jalpesh Vadgama) — Sat, 10 Feb 2018 17:13:00 +0530

In this blog, We are going to see how we can install the node.js and npm on the Debian Operating system. So let’s get started.

First of all Either you should use “Sudo” command or use your root users to run all this command so that it will be available to all the users on this machine.

So first we need to install node.js so for that there are multiple ways but I am going to use node source binary distribution so that we can get latest stable version of node.

You can find node source binary distribution at - https://github.com/nodesource/distributions

First, You need to run the following command.

curl -sL https://deb.nodesource.com/setup_8.x | bash -

After that run the following command.

apt-get install -y nodejs

Then you need to install NPM for that you need run the following command.

curl -L https://npmjs.org/install.sh | sudo sh

Then you can check node.js version with node -v like shown in below image.

That’s it. Now create your favorite node.js application. Hope you Enjoyed it. Stay tuned for more!!

4 Million Page Views and 800 blog post completed for my blog- dotnetjalps.com

noreply@blogger.com (Jalpesh Vadgama) — Wed, 7 Feb 2018 23:37:00 +0530

As you know that I’m not super crazy about blog milestones but this is a special one and I could not resist sharing with you guys. This blog completed 4 Million Page Views and This is the 801st blog post I’m writing. What an amazing journey for this blog.

On this occasion of 4 million pages views I would like to thank my readers, friends and Mentors without them it was not possible. THANK YOU VERY EVERYONE

This blog has started as a quest to see my name in search engines and then I got serious into blogging and then onwards never looked back. Again I am very thankful to my readers without their it was not possible. I host my blog on blogger.com so here are some of statistics on my blog.

And here is the top 10 blog post for all time.

From the statistics, you can see I’m getting about 70,000 page views every month. and More than 3000 page views every day. This all done with genuine search engine optimization provided blogger.com. Also, I started tracking my page views from 2010. So actually it's more than 4 million page views.

On this occasion, I would definitely like to Thank my Wife Reeana and all the family members who sacrifice their time when I write this blog.

Now I will try to be more punctual about writing blogs and hopefully, you will get lots of new stuff like ASP.NET Core, SQL Server, My SQL, Linux, Node.js, Angular, Vue.js as I learned a lot of this new technologies and will share my experience with you guys.

Once again thank you all readers without you guys It would not have been possible.

Solved: Microsoft SQL Server Error 3403

noreply@blogger.com (Jalpesh Vadgama) — Wed, 7 Feb 2018 23:08:00 +0530

This is a Guest Post from “Andrew Jackson”.

Bio of Andrew Jackon:
He is freelance SQL Server DBA. He is fan of technology, programming, and entrepreneurship. He is also interested in writing and web development and SQL Server blogger too. He like to share about SQL Server and the problems related to it as well as their solution and also He also handles database related user queries, server or database maintenance, database management etc.

You can find his social handles at following.

Facebook: https://www.facebook.com/people/Andrew-Jackson/100008825676608
Twitter: https://twitter.com/jacksonandrew32
LinkedIn: https://www.linkedin.com/in/jackson-andrew-401147a5/

You find more about him at : https://about.me/theandrewjackson

From its powerful internal structure, fast performance, and reliability, SQL server is now widely accessed by several enterprise users. It is used to deal with bulk transaction processing, business programs, and content management. The Microsoft SQL server is chosen for its high-level security, scalability, and performance. Sometimes, corruption in the SQL database occurs due to the saving of a large amount of business information. This problem makes the server inaccessible, flashing an error message on the window.

One such message is ‘SQL server error 3403’, resulting in an unplanned downtime of the server.

Reason for SQL Server Error 3403:

Corruption and the server crash these two are the most common and root causes of the problem. Once the server crash takes place, the database verifies the transaction log. But, if the provided information does not match Object ID then, the application throws an error code 3403. It is possible that instead of these reasons there is some other cause of the problem. Following are those additional causes of SQL server error 3403 :

While updating the allocation page, the data gets written on the transaction log before the crashing takes place.
Another cause of the problem might be bad allocation activity by Microsoft SQL server.

How to Fix SQL Error 3403?:

The best way to deal with any of the SQL server error (including 3403) is to restore data from the recently created backup file. If you are having the backup file then, you just need to perform following steps :

First of all, drop the SQL server database and then, create a database for loading.
It’s time to restore database file and utilize online commands for activating restored files for use.

Note: Verify that the database files created at present must be having same size as of Sysusages value.

Alternative Solution to Fix SQL Server Error 3403:

It is possible that users might not be having a backup file with them. In such case, the only approach is to use SQL Recovery software, which restores the corrupt database with an ease. The software is a rapid technique for fixing SQL database files corruption without any efforts. What all you need to do is just browse corrupt MDF file. If you are unaware of corrupt SQL database location then, no need to worry because the software provides the solution for it. This product is also capable of recovering data from corrupt files, which are encrypted by Wallet Ransomware attack.

Conclusion:

Errors are uncertain situations, which acts as challenges for an individual. If an accurate workaround is not executed then, these situations can also result in another hazardous condition. It should be the duty of each and every server user to fix the error, just after their occurrence. There are two solutions on how to fix SQL error 3403 i.e., backup file restoration and SQL database recovery program. As per the availability, readers are free to catch any of the workarounds for resolving their problem.

Creating Rest API with Node.js,Express and MySQL Part-1

noreply@blogger.com (Jalpesh Vadgama) — Sun, 3 Dec 2017 16:04:00 +0530

With Node.js and express creating a Rest API is a piece of cake. In this blog post, we are going to see how we can create a rest API with Node.js, Express, and MySQL as a database.

Creating Database with MySQL:

So let’s first with creating Database for our APIs. So todo that we need to create a new Schema from MySQL workbench like following.

Here we are going to create a schema(database) called “employee”. Then it’s time to create a Database Table and Let’s create a table like following.

and Here is the SQL Script for creating a table.

Here we have 4 column of the table EmployeeId(Primary Key), First Name, Last Name and Designation of employee details.

CREATE TABLE `employee` (
  `EmployeeId` int(11) NOT NULL,
  `FirstName` varchar(45) DEFAULT NULL,
  `LastName` varchar(45) DEFAULT NULL,
  `Designation` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`EmployeeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I have entered some sample data like following.

Express Node.js application to create Rest API:

Now we have our database ready for MySQL and It’s time to create a new Node.js Express application. We can start with creating Package.Json with NPM init and run that command in command line.

npm init

It will ask you several questions to create your node an application like below.

Once your basic node.js application is ready It’s time to install express via the following command.

npm install express –save

It will install express like below.

Now we have created a node.js and express application. I have also installed MySQL and BodParser package and here’s how the package.json looks like.

{
  "name": "nodejsmysql",
  "version": "1.0.0",
  "description": "A Rest API Example with Node.js and MySQL",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "Jalpesh",
  "license": "ISC",
  "dependencies": {
    "body-parser": "^1.18.2",
    "express": "^4.16.2",
    "mysql": "^2.15.0"
  }
}

As now we are done with creating and configuring our node.js application It’s time to write code. First I have written following code to create a route of our API which will be a map to our API URL.

var express = require("express");
var app = express();
var bodyParser = require("body-parser");

app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());

var port = process.env.por || 3000;
var router = express.Router();

app.use("/api/employee", router);

Here in the above code, you can see that I have created an express object as required and then I created a body-parse object which will be used for the posting/putting data into our API. Then I have created a port and get router of express and then created a route which will be our URL for API.
Now It’s time to write MySQL Connection code like below.

var mysql = require("mysql");

var con = mysql.createConnection({
    host: "youripformysql",
    user: "usrename",
    password: "password",
    database: "employee"
});

In the above code I have to get MySQL object via require and then I created a MySQL connection. You need to pass the credentials there for your MySQL Credentials. Then I have written following code to get Employee table data with our get API.

router.get("/", function (req, res, next) {
    con.connect(function (err) {
        if (err) throw err;
        con.query("SELECT * FROM employee", function (err, result, fields) {
            if (err) throw err;
            res.send(JSON.stringify({
                "status": 200,
                "error": null,
                "response": result
            }));
        });
    });
});

Here in the above code, You can see that I have written Route.get method which will be used to get All Employees from the MySQL database and then I have written a Select Query to query data with “Employee” table. Then I have put result data as Json with the response object.
Now we have to start this application with app.use like the following code.

app.listen(port, function () {
    console.log("Express server running on port %d", port);
});

Now we can run the application with the following command.

node index.js

You can see same in above image.

Now in a client like postman you can see the output like below.

That’s it. In blog post series we will see that how we can add/update and delete it. Stay tuned for more!!.

You can find complete source code above blog post at following location on github- https://github.com/dotnetjalps/RestAPINodeMySQL

Video: How to use IIS Express with Visual Studio Code

noreply@blogger.com (Jalpesh Vadgama) — Sat, 25 Nov 2017 12:28:00 +0530

Visual Studio Code is a Great Editor by Microsoft being Developed Open Source on Github and It is gaining lots of popularity and lots of Developers are using for creating applications in various languages. Their lots of features that are there for Developers and Still lots of features is not been explored or lots of useful extensions are not being explored. So I am creating few videos for explaining it’s feature and this video is one of that features.

IIS Express is a built-in web server for C# applications with Visual Studio and lots of Developers are using this. This video explains how we can use IIS Express with Visual Studio code. Please have a look at it and let me know how it was.

The plugin used in this video can be found at following location.
https://marketplace.visualstudio.com/items?itemName=warren-buckley.iis-express

And If you don’t know what is Visual Studio code then you find more about it at following location.
https://code.visualstudio.com/

Stay tuned for more!!.

Microsoft MVP for the 6th time! Thank you, Microsoft

noreply@blogger.com (Jalpesh Vadgama) — Sun, 9 Jul 2017 11:35:00 +0530

First all, Sorry for the late post. I am very happy and proud to announce that I have been awarded Microsoft Most Valuable Professional for the 6th time in “Visual Studio and Development" Category.

On this occasion, I would to Thank Microsoft for again such a wonderful gesture. I would also like to thank my MVP Community lead Deepak Rajendran & team for their constant support. I would like to thanks, Biplab Paul and Gadharv Rawat for doing same earlier. Without the support of these guys, it would not have been possible to achieve this.

Also, I would like to thank my family for their constant support for compromising their time to do the community work. Special thank to my wife Reena. Behind every men’s success, there is a woman and she is the woman responsible for my success. I would like to dedicate this award to my family this time especially my little champ who is the inspiration for me to staying strong in any condition.

Also, I would like to thank Ahmedabad User Group and Microsoft for providing awesome opportunity to speak at various events.

Last but not least, THANK YOU my dear blog readers without you. It was not possible.

Video: How to debug Node.js Application with Visual Studio Code

noreply@blogger.com (Jalpesh Vadgama) — Sun, 9 Jul 2017 10:54:00 +0530

Visual Studio code is a Great Editor and I like it very much. It support’s a lot of cool features our of box. Node.js Application debugging is one of them. It provides great debugging with node.js just like Visual Studio. I have created a small video demonstrating the same. Please have a look.

Video: Visual Studio 2017 Features

noreply@blogger.com (Jalpesh Vadgama) — Wed, 21 Jun 2017 07:18:00 +0530

Visual Studio 2017 got lots of new features and so that I’ve created a new video for demonstrating all the features of video. Please have a look at that video at below.

Let me know what kind of video you want to watch more!. Stay tuned for more!

Code Navigation features in Visual Studio Code

noreply@blogger.com (Jalpesh Vadgama) — Sat, 17 Jun 2017 13:08:00 +0530

Visual Studio Code is an open source, free, Cross-platform editor and I have been using it now more than the year. I just simply loved this editor. It’s a got lot of feature and there are some cool navigation features there. In this blog post, we are going to explore those navigation features.

Quick Open File Navigation Features(Ctrl+Tab):

If you press Ctrl + Tab then it will show all the open files in Visual Studio Code.

Go To Definition(F12):

If Language is supported in Visual Studio Code then you have that feature available just like have it in full Visual Studio IDE. You can press F12 to go to definition and the same way you can also right click and select Go To Definition.

Peek Definition(Alt + F12):

Peek Definition is working same as Go To Definition the only difference is it will load a windows inline and show. It is quite useful when you want to quickly see something. You can use this feature via pressing Alt+F12.

Open Symbol(Ctrl+T):

It also contains some Resharper like features you can go to any symbol via pressing Ctrl + T. Just type the first letter of a type you want to navigate to, regardless of which file.

Go To File(Ctrl + P):

You can also go to any file with Go To File feature of Visual Studio code via pressing Ctrl + P. This quite useful when you have large code base.

There tons of other features available with Visual Studio code. So if you have not tried this editor I would highly recommend to try it. I’m sure you fall love in it. You can download Visual Studio code from the following location.

https://code.visualstudio.com/

Stay tuned for more!.

My blog awarded top 60 Dot Net Blogs on Web from FeedSpot

noreply@blogger.com (Jalpesh Vadgama) — Sat, 13 May 2017 10:37:00 +0530

It’s been a great year for me overall. It was a roller coaster ride for me. Recently I got an email from Anuj Founder of FeedSpot that My blog has been awarded as Top 60 DotNet Blog from FeedSpot.

You can find complete list of Top 60 blog at following link.

http://blog.feedspot.com/dotnet_blogs/

My blog at 22 positions there.It’s great pleasure being part of Top 60 Dot Net Blog in Web. On this occasion I would like to thank my Family without there support it was not possible to bee there. Specially my wife Reena who sacrifies her time when I’m writing blog posts. Also I, would like to thank my entire audience and readers without them it was not possible to achieve such a great milestone.

Thank you very much everyone!!. Please keep reading my blog. Stay tuned!

Global Azure Bootcamp 2017 by Ahmedabad User Group, Ahmedabad–A great event

noreply@blogger.com (Jalpesh Vadgama) — Thu, 27 Apr 2017 08:09:00 +0530

The last Sunday on 22nd April 2017, We had great event 5th Annual Global Azure Bootcamp.

What is Global Azure Bootcamp:

If you have not heard about Global Azure Boot. It is the great event for learning and understanding Microsoft Cloud Platform Azure. There were more than 250 locations in the world where this event took place. Each user group or community has organized their own one day deep dive seminars on Azure to see how it can be useful to develop great applications.

You can find more about Particular event on the following location-
https://global.azurebootcamp.net/

About Global Azure Bootcamp 2017 Organized By Ahmedabad User Group:

First of all, I would like to thank our local sponsor Aptus who provided us the Venue for organizing the event. Thank you so much!

The Day was started by Keynote presentation from Mahesh Dhola by introducing what is Global Azure Bootcamp and how any developer can get benefited from this. He explained how great azure is and what is Agenda for this event.

Then It’s my time to be on stage. I have taken session about Introduction to BOT Framework. It is the latest offering from Microsoft. I have explained all the bits of BOTS evolution and How easily we can create a great BOT in minutes. Even I have shown How we can make our BOT intelligent via adding LUIS which is a language understanding service from Microsoft.

Following is my presentation about events.

Introduction to BOT Framework- Global Azure Bootcamp 2017 from Jalpesh Vadgama

I had a great time presenting this topic and Audience was quite interested in this topic. We had some great question and answers.

You can find source code that particular session at https://github.com/dotnetjalps/GAB2017

After that, There was a Session from Nirav Madariya. He has taken a session about Logic Apps and Azure Functions. Here he has explained how we can easily create logic apps. Then he has explained Azure functions. He explained how we can create a server-less architecture with Azure Functions.

After that, there was a session from Kalpesh Satasiya. He has taken session about Microsoft Cognitive Services. Where he explained various services provided by Microsoft Cognitive services i.e. Vision, Language, Knowledge, Speech, and Search.

And here you can find his presentation

Microsoft cognitive services Global AzureBootCamp 2017 from Kalpesh Satasiya

After that there was a time for Lunch and we had great opportunity to have networked with each other.

We had great fun doing networking with each other. Also enjoyed lunch. Thank you, Microsoft for sponsoring it.

After that, there was a session from well known Microsoft Regional Director and MVP Prabjhot Baxi. He explained about Azure IOT suite. How we can add devices into Azure IOT hub. He also explained Azure IOT hub and stream analytics and how to store data in Azure Document DB.

Then we had a great session from Kaushal Bhavsar about Log Analytics. It is not a popular feature of Azure But after attending his session I found it is quite useful. He explained about how we can enable various kind of logs with Logs analytics. Even he showcased a demo with adding agent in Linux server and seeing what logs are there.

After that Ahmedabad User Group president Mahesh Dhola. He had taken session about Open Source Technology at Microsoft, Azure Virtual Machines. He also showed a demo how we can host elastic search on Azure Linux Virtual machine.

Overall, It was a great event and Audience was also good.

It was one of the successful events we have. Thank your all the sponsors and Audience.
If you want to be part of such event or want to be a speaker at the event please contact me or AhemdabadUserGroup twitter handle.

https://twitter.com/AhmedabadUsrGrp

We are soon going to organize the Visual Studio community launch stay tuned for the same. #GlobalAzure

Explicit loading in Entity Framework Core

noreply@blogger.com (Jalpesh Vadgama) — Sun, 2 Apr 2017 17:44:00 +0530

In this blog post, We are going to learn about Entity Framework feature. Explicit loading means that related data is explicitly loaded from the database at a later time. As you might know, that lazy loading is still not possible with Entity Framework core but there is a way to explicit load related data in a transparent manner. We are going explore how we can load data explicitly with entity framework in this blog post in detail.

How to do Explicit loading in Entity Framework Core?

To demonstrate how we can use explicit loading in Entity Framework core. We are going to create a console application with two entities Student and Department. A department can have multiple students. Here we are going to see how we can load students for each department explicitly.

So let’s create a console application like following.

Now once you click “Ok” it will create a console application. Now let’s add nuget package for entity framework core in console application like following. You need to run following command in Package Manager Console.

Install-Package Microsoft.EntityFrameworkCore.SqlServer

Now it’s time to create our models for Student and Department like below.

Department:

using System.Collections.Generic;

namespace EFCoreExplicitLoading
{
    public class Department
    {
        public int DepartmentId { get; set; }
        public string Name { get; set; }
        public ICollection<Student> Students { get; set; }
    }
}

Student:

namespace EFCoreExplicitLoading
{
    public class Student
    {
        public int StudentId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public int DepartMentId { get; set; }
        public Department Department { get; set; }
    }
}

Now let’s create an Entity Framework Core context like below.

using Microsoft.EntityFrameworkCore;

namespace EFCoreExplicitLoading
{
    public class StudentContext: DbContext
    {
        public DbSet<Student> Students { get; set; }
        public DbSet<Department> Departments { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(@"Data Source=SQLServerName;Initial Catalog=YourDatabase;User ID=UserName;Password=Password;MultipleActiveResultSets=true");
        }
    }
}

Here in the above code, you see that A department can have multiple students and A student can have only one department so there is one to many relationships between department and student.

Now let’s create a migration to create the database for the same. To enable migration we need to install following nuget package for entity framework core tools.

Install-Package Microsoft.EntityFrameworkCore.Tools

Now let’s create a migration with the following command.

Add-Migration InitialDatabase

Now let’s create a database with “Update-database” in Package manager console. It will create a database.

Now we need some initial data to demonstrate the explicit loading feature so I’ve added following data into Departments table.

Same way I have added data into Students table like following.

Now it’s time to write some code that demonstrates the explicit loading feature of entity framework core. Following is a code for the same.

using System;
using System.Linq;

namespace EFCoreExplicitLoading
{
    class Program
    {

        static void Main(string[] args)
        {
            using(StudentContext studentConext= new StudentContext())
            {
                var deaprtments = studentConext.Departments.ToList();
                foreach(var department in deaprtments)
                {
                    Console.WriteLine("Before explicit loading");
                    Console.WriteLine(department.Students==null);

                    //loading student explicitly
                    studentConext.Entry(department).Collection(s => s.Students).Load();

                    Console.WriteLine("After explicit loading");
                    Console.WriteLine(department.Students == null);
                    Console.WriteLine(department.Students.Count);
                    Console.WriteLine("------------------------------------------------");

                }
                Console.ReadLine();
            }
        }
    }
}

Here in the above code, you can see I have created student context object and then I have got all the databases. After that, I have checked that whether each department is having students or not. In the next statement, I have loaded the students explicitly with the student with collection load method and then again I checking whether it got students and also printing count of a student.

Now let’s run this application and here is the output as expected.

So it is loading student data after the department is loaded with the help of explicitly. That’s it. Hope you like it. There are so many scenarios where this explicit loading can be quite useful. Stay tuned for the more!!.

The complete source code of this sample application is available on github at - https://github.com/dotnetjalps/EFCodeExplicitLoading

How to integrate HangFire with ASP.NET Core 1.1

noreply@blogger.com (Jalpesh Vadgama) — Sun, 2 Apr 2017 11:54:00 +0530

Hangfire is one of the easiest ways to perform background processing in.NET and.NET Core Applications. In this application we are going to learn how we are can integrate Hangfire with ASP.NET Core application.

About Hangfire:

Hangfire allows you to create background task in.NET applications. It’s extremely easy to integrate. It allows you to kick off method calls outside of the request processing pipeline in very easy but reliable way. You can store those jobs in on premise SQL Server, SQL Azure, Redis, MSMQ or Redis.

You can find more information Hangfire on the following link.
http://hangfire.io/

Hangfire also contains one of very maintained documentation at the following link.
http://docs.hangfire.io/en/latest/

Integrating HangFire with ASP.NET Core 1.1:

To demonstrate how we can integrate with ASP.NET core, I’m going to create a new ASP.NET Core application in Visual Studio 2017 like below.

Once click on it will ask for the selection of Application task we are going to select Web Application like below.

As our application is not ready, We are going to install Hangfire nuget package in the application.

Now we are done with adding Hangfire to our asp.net core application. We need to create a SQL Server database for Hangfire application. Here I’m going to use SQL Server for Job storage but there are various Job Storage options available as mentioned above.

Now we need to have ConnectionString for the database. Let’s put it on appsetting.json like below.

{
  "ConnectionStrings": {
    "HangFireConnectionString": "Data Source=SQLServer;Initial Catalog=HangFireSample;User ID=YourUserName;Password=YourPassword;MultipleActiveResultSets=true"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Warning"
    }
  }
}

Now in Startup.cs file configure services method we need to integrate hangfire like below. Here I’ve added hangfire to our application and also indicated that we are going to use SQL Server for Job storage and provided connection string for the same.

public void ConfigureServices(IServiceCollection services)
{
    // Add framework services.
    services.AddMvc();
    services.AddHangfire(config=>config.UseSqlServerStorage(Configuration.GetConnectionString("HangFireConnectionString")));
}

Now Hangfire integration is easy to use. When you run it will automatically create tables related to Hangfire configuration and storage as below.

Now you can easily add background task like below at any place.

  BackgroundJob.Enqueue(() => Console.WriteLine("BackGroundJob"));

Even you can add recurring job which will run at a specific time like below.

 RecurringJob.AddOrUpdate(() => Console.WriteLine("RecurringJob"), Cron.Daily);

That’s it. You can see it’s very easy to use and You can integrate Hangfire very easily. Hope you like it. Stay tuned for more!.

You can find complete source code of this application at following on github.com : https://github.com/dotnetjalps/ASPNetCoreHangFire

New Features–Out Variables in C# 7.0

noreply@blogger.com (Jalpesh Vadgama) — Wed, 29 Mar 2017 23:32:00 +0530

Prior to C# 7.0, For out keyword, we need to define that variable earlier and then we were able to pass that variable as out reference arguments. But now with C# 7.0, You don’t need to declare the variable but you can use the variable which you have used in arguments.

Following is a code showing both ways passing out variables.

In the above code, You can see that I have created get employee static method which put some values in this out variables. First I have shown the old way of doing this. Where I explicitly defined the variables and then passed it to function while in the new way of doing you don’t need to explicitly define variable. You can write this as an argument and then, later on, you can use the same variable in next statements. Now when you run the application, the new and old way both produce the same output.

You can find complete source code of this examples at following location on Github at- https://github.com/dotnetjalps/CSharp7NewFeatures

Visual Studio 2017 New Features Series

noreply@blogger.com (Jalpesh Vadgama) — Wed, 29 Mar 2017 01:43:00 +0530

Visual Studio 2017 is recently launched by Microsoft and it is one of great IDE I have ever seen. It contains lots of features and this blog post contains the link to all features post that I have written for Visual Studio 2017.

A new start page for Visual Studio 2017
Code Navigation features in Visual Studio 2017

Code Navigation features in Visual Studio 2017

noreply@blogger.com (Jalpesh Vadgama) — Wed, 29 Mar 2017 01:27:00 +0530

This blog post is a part of Visual Studio 2017 New feature Series

TL;DR:

With Visual Studio 2017 there are lots of new Code Navigation features introduced. We are going to look all the options available in Visual Studio 2017.

Navigation your code with Visual studio 2017:

Visual Studio 2017 have newly refreshed code navigation features which help you moving from point A to B easily and fewer distractions. There are mainly four new features available.

Go to Implementation(Ctrl+F12):

It helps you navigate from any base type to implementation of the concrete type.

Go To Line(Ctrl+G):

It helps moves cursor from current line to specified line number.

Go To All(Ctrl+T):

It helps you navigate directly to any file/type/symbol/member. You can move from any files to anywhere with this feature easily.

Go To File(Ctrl+ 1, Ctrl + F):

You can easily navigate between files with this feature.

Go To Type(Ctrl+1, Ctrl + F):

You can move to any type with this feature. It searches classes/interfaces/enums and delegates and moves your current cursor selected type.

Go To Member(Ctrl+ 1, Ctrl + M):

You can move between members for a particular class. It searches Global Variables and Global Functions, Class Member variables and member functions, Constants, Enum items, Properties, and events.

Go to Symbol(Ctrl + 1, Ctrl + S):

You can move to any symbols, search result includes Go to Type and Go to Member.

Find All References(Shift + F12):

In the earlier version of Visual Studio Find All References was the plain list without any syntax highlighting and coloring. Now with Visual Studio 2017 it has got coloring and splits all the information into their respective columns. This column can be also customized so you will only see what you want to see in Find All References Window.

So Visual Studio 2017 now got lots of features and that will make code navigation very easy. It will definitely increase developer productivity and made life easy.

A new start page for Visual Studio 2017

noreply@blogger.com (Jalpesh Vadgama) — Tue, 28 Mar 2017 00:04:00 +0530

This blog post is a part of Visual Studio 2017 New feature Series

Recently Microsoft has released a new version of Visual Studio 2017 and as usual, there are tons of features available with Visual Studio 2017. Visual Studio has always been one of my favorite IDE. We are going to look into all the features one by one. The first thing when you launch a New instance of the Visual studio will launch a start page. So in this blog post, we are going to explore what’s new in start page of Visual Studio 2017.

A new start page for visual studio 2017

The first thing once you load visual studio 2017 will have a start page. It has been divided into three columns. The first column contains Get Started and Recent sections. The second column contains Open Project and New Project section and the third column contains Developer new section. By default when you load Visual Studio it looks like following.

Get Started and Recent Section of Start Page:

Get Started section of Visual Studio 2017 contains how you can get started with Visual Studio. It contains a variety of links including how to get started with Visual studio to how to extend visual studio.

The recent section contains recently open projects. It is divided into two part Today and Last week. Today section contains the link to the project that is opened today in Visual Studio. Last week section contains projects that are used during last week.

Open and New Project Section:

The open section contains four things.

A link to connect Visual Studio team services from where you can directly connect to a team services project and open it from there.
Open Project/Solution: - Open project or solution works in same as the earlier version of Visual Studio. It open project or solution available on your computer.
Open Folder: - It will open a folder available on your computer and then display all the code files available in that particular folder.
Open Web Site: This works same as earlier of Visual Studio. It opens an ASP.NET Web Sites available on your local computer.

New Project is brand new in Visual Studio 2017. By default, it shows the recent project's templates you recently used and also there is search box to search the templates available in Visual studio 2017.

Even you search templates via putting some text in the search box like following.

So now to create a new solution or project you don’t have go to file menu. You can directly create a new project from start page itself.

Developer News Section:

This developer new section contains new feeds from various sites.

Customize Start page in Visual Studio 2017:

Like earlier edition of Visual Studio, you can also customize the start page of Visual Studio 2017. There is an option available for the same under Tools-> Options menu. Select environment and Goto Startup following dialog will come.

Here you configure options like At startup what should be shown. You can also setup time to download the content of developer news. Also, you can also use customize start page.

That’s it. Hope you like it. Stay tuned for more!!.

New Blog theme- new technologies

noreply@blogger.com (Jalpesh Vadgama) — Mon, 27 Mar 2017 23:02:00 +0530

This blog has been quite for the some time. I was busy doing some professional commitments but now I decided to write blog post regularly. As there are lots of interesting stuff happening in technology world. There are tons of new technologies coming up and lots of new things to learn.

New blogger theme:

Recently blogger.com has launched few new theme and I also decided to have new blogger theme on my blog. I have used “Contempo” theme for my blog. This time I have done some experiments I have not changed anything except the background feature. Let’s see how it goes with SEO and other stuff. Here is new look of my blog.

Hope you will like it.

New Technologies to blog :

There are lots of stuff happening in technology and I started learning those technologies and I’m going to share my learning experience with you guys for sure. So do except blog post on following topics.

Visual Studio 2017
ASP.NET Core 1.1
C# 7.0
Entity Framework Core
.NET Core cross platform
Docker
Node.js
Golang
SQL Server 2016
MongoDB
Azure and Different Azure services
Angular 2/4.
React
Vue.js

I outlines few of technologies there but still there are lots of happening so Please put your comments that what technologies I should learn and blog about.

As always, Again thank you very much for the your support and love. Without your support this blog would have not have been exist. Thanks all as always.

Happy blogging and journey continues.