Author Archives: Obi Oberoi

About Obi Oberoi

I am Technology Aficionado who has a passion for learning, speaking, blogging and hanging out with geeks and like minded people!

How to Extend Session in ASP.NET

If you are building a web app using “Forms” as a mode of authentication, there’s really not much to it when it comes to extending a session automatically. What I am suggesting is that your web session will extend on … Continue reading

Posted in jQuery | Leave a comment

What is Blazor and Why should you Use it!

Introduction: According to Microsoft Docs, Blazor is a framework for building client-side web UI with .NET. It’s a feature of ASP.NET, the popular web development framework that extends the .NET developer platform with tools and libraries for building web apps. … Continue reading

Posted in UI Framework | Leave a comment

How to Call a UDF using ADO.NET

Let’s face it, most of us typically work with Stored Procedures with modest complexity using JOINS and such. Some of us embed Common Table Expressions (CTE) in the stored procs. If you are already using Entity Framework 2.2, you would … Continue reading

Posted in .NET, ADO.NET, SQL Server | Leave a comment

How to Enable .NET Core 3.0 Preview in VS2019

If you are in the process of creating a Blazor app in Visual Studio 2019 that you installed right after its launch (around April 2019 timeframe), chances are you’ll find the checkbox titled “Use previews of the .NET Core SDK” … Continue reading

Posted in .NET | Leave a comment

Migrate SQL data to Azure Cosmos DB

Azure Cosmos DB Azure Cosmos DB is a planet scale, JSON based schema free, No SQL database with multi-API support. Microsoft defines it as a globally distributed, multi-model database service that supports document, key-value, wide-column and graph databases. In this … Continue reading

Posted in NoSQL | Leave a comment

Entity Framework Core 3.0 Preview 4

Diego Vega, the Program Manager of the Entity Framework team recently announced on his blog some of the breaking changes in ASP.NET Core 3.0 Preview 4. Some of these changes include the following: LINQ queries are no longer evaluated on … Continue reading

Posted in ORM | Leave a comment

Cannot connect to runtime process, timeout after 10000 ms

If you are a web developer, it’s given that you also write JavaScript code. I am building an ASP.NET Core app in VS 2017 and I needed to install a feature that I chose to write in JavaScript. While everything … Continue reading

Posted in Uncategorized | Leave a comment

Query Types in EF Core

If you have been using Entity Framework 6.x or EF Core, then you are already familiar with Entities and its usage. Query Types is a new addition to EF Core 2.1 which you can refer to Entities as its cousin. … Continue reading

Posted in .NET, ORM | Leave a comment

Data Seeding in EF Core

Data seeding is a process where you populate the initial set of data into the database. I’ll explain some of the rudimentary steps needed for creating seed data in your app. Prior to EF Core 2.1, seeding data was not … Continue reading

Posted in .NET, ORM | Leave a comment

Import CSV into SQL Server using VBA

You have heard the famous clichรฉ, “there are many ways to skin a cat”. That said, there are many ways to import a flat file into SQL Server. Some of them include the following: SSMS – Select Database -> Right … Continue reading

Posted in SQL Server | Leave a comment