.NET Core 3.0 was announced yesterday at the Microsoft Build event and let’s welcome .NET Core supports for Windows Desktop applications. Finally, this is happening as developers were asking for desktop applications with .NET Core. The highlight of .NET Core 3 is support for Windows desktop applications, specifically Windows Forms, Windows Presentation Framework (WPF), and UWP XAML. You will be able to run new and existing Windows desktop applications on .NET Core and enjoy all the benefits that .NET Core has to offer. (more…)
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.
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…)
Last week, .NET Core 2.0 preview 1 was announced along with ASP.NET Core 2.0 and .NET Standard 2.0. There are lots of new stuff to play with, but this post is focuses on .NET standard 2.0. At the time of writing this post, it is preview 1 release of .NET standard 2.0 and it’s impressive. This post talks about installing .NET standard 2.0 and find out what’s new in .NET Standard 2.0. (more…)
There are many new features introduced in Entity Framework Core (EF Core). And one of the most awaited feature is, batching of statement. So what exactly batching of statement is? Batching of statement means that it doesn’t send individual command for every insert/update/delete statement. It will batch multiple statements in a single round trip to the database. So In this post, let’s see how it works and then compare the results with EF6.
As mentioned in my earlier post Quick summary of what’s new in Entity Framework Core 1.0, “Shadow Properties” is one of the new feature of Entity Framework Core. Shadow Properties are fields which are not part of your entity class so they don’t exist in your class but they do exist in entity model. In this post, let’s find out how to use shadow properties in Entity Framework Core. (more…)
Entity Framework Core supports different key generation strategies like identity, Sequence and HiLo. In my previous post, I talked about using SQL Server Sequence with EF Core to Create Primary Key. Database sequences are cached, scalable and address concurrency issues. But there would be a database round-trip for every new the sequence value. And in case of high number of inserts this becomes a little heavy. But you can optimize the sequence with HiLo pattern. And EF Core supports “HiLo” out of the box. So in this post, we will see how to use HiLo to generate keys with Entity Framework Core. (more…)