Skip to main content

Transfer SQL Server Database data to MySQL Database using .NET Core – Part 2

This is in continuation of the Part-1 solution to transfer SQL Server Database data to MySQL Database using .NET Core. If you have not read the first post, please go through it. To give you an overview, the part-1 solution gets all the SQL server database data and creates a serialized and compressed version of a dataset. The part-2 or final solution downloads the compressed file and populates the MySQL database. Let’s see how this is achieved.
(more…)

Read More

Transfer SQL Server Database data to MySQL Database using .NET Core – Part 1

Transferring one database data to other databases is not challenging when source and destination database type is same. It becomes a nightmare when source and destination database types are different. To save you from this nightmare, there are plenty of products available for data transfer between different types of databases. But, these tools come with a very high price. I also got into a similar problem and thought of buying one of the products. As you know in a typical software company, buying a licensed product is a time-taking process that requires lots of approvals and justifications. While the process was on, an idea struck and got the solution to transfer SQL Server Database data to MySQL Database using .NET Core. (more…)

Read More

Store complex objects in ASP.NET Core Session

The ASP.NET Core Session object has 3 methods to set the session value, which are Set, SetInt32 and SetString. The Set method accepts a byte array as an argument where the SetInt32 and SetString method are the extension methods of the Set method. These methods internally cast the int or string to a byte array. Similar to these, there are 3 methods used to retrieve the value from the session: Get, GetInt32 and GetString. There is no method available to store complex objects in session, and this post shows how to store complex objects in ASP.NET Core Session. (more…)

Read More

Validate Model State automatically in ASP.NET Core 2.0

A ModelState is a collection of name and value pairs submitted to the server during a POST request. It also contains a collection of error messages for each value. The Modelstate represents validation errors in submitted HTML form values. Model validation is the first statement in each controller action method to check for any error before moving forward. A familiar piece of code.

The IsValid property will be true when the values are attached correctly to the model AND no validation rules are broken in the binding process. However, writing this piece of code in every action method increases efforts, lines of code and repetitiveness. It would be appropriate to make model validation a reusable piece or even better would be to automate this process. This post talks about how to validate model state automatically in ASP.NET Core 2.0.
(more…)

Read More