C# Corner

Resources  
  • SQL Server Updates Tricked Me For YearsApr 24, 2018. When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you already had stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer rules.
  • Firebase CRUD Operations Using PythonApr 23, 2018. You need to be logged in with a Google account which can use the Firebase console and follow the below steps to create a Firebase database.
  • Working With In-Memory Database - RedisApr 22, 2018. In this article we will see how to implement Redis in-memory database in C# .Net applications
  • Retrieve Real-Time Data In Firebase Using Android StudioApr 20, 2018. Data retrieval is the process of identifying and extracting data from a database, based on a query provided by the user or application. It enables the fetching of data from a database in order to display it on a monitor and/or use within an application.
  • Student Info In Xamarin.Forms Application Using SQLite For Android And UWPApr 19, 2018. Reading this article, you can learn how to perform local database operation in Xamarin Forms application using SQLite for Android and Universal Windows Platform with XAML and Visual C# in cross-platform application development.
  • Just Check ALL The BoxesApr 17, 2018. Today I ran into something on a client-server that unfortunately I see too often. The DBA goes through the trouble of configuring and setting up alerts/operators but doesn’t really understand what the options in the configurations mean. So, unfortunately, that means they take the CYA (cover your ass) approach and they check all of them. Now, not only have I seen this with alerts but also with things like security configurations as well. My advice is to always take a second and research what each option is before you check the little boxes, especially when it comes to security. Always follow the rule of less is more.
  • Azure SQL Database - Create And Connect SQL Database In The Azure PortalApr 11, 2018. This article explains how to create and connect Azure SQL database to the Azure portal.
  • CRUD Operation In Angular - Angular + Core 2.0 CRUD Operation - Part TwoApr 11, 2018. In my previous post (Part I), I explained how to do Database first in .Net Core 2.0 and we created Employee Web API by Database first approach.
  • How To Upload Audio In Database And Play In GridView Using ASP.NETApr 10, 2018. In this article, we are going to discuss how to upload an audio file in our project folder and save its path in SQL server database table.
  • WCF And ListView Insert Update And Delete Rows In ASP.NETApr 09, 2018. In this article you will learn how to edit, update and delete in ListView. First drag and drop ListView. In ListView, next open Default.aspx source code. To make a column in Listview use <LayoutTemplate>. Here first I created a table name 'Product' in my database. It contains 5 columns: ProductId, ProductName,ProductLocation,ProductQuantity, and ProductPrice.
  • How To Upload Video In Database And Play In GridView Using ASP.NETApr 08, 2018. In this article we are going to learn how to upload video in project folder and save its path in SQL server database table. We will bind that table to gridview and play audio using html5 video element.
  • Create Music Remote System Using BBC Micro :BitApr 06, 2018. At the end of this tutorial, you will be able to control your phone's music player using Micro:Bit.
  • Xamarin.Android - Develop SQLite Database Using SQLiteOpenHelper ClassApr 05, 2018. In this article, you will learn to create your own database for Xamarin Android.
  • How To Read Temperature Using BBC Micro:Bit Mar 31, 2018. In this tutorial, I am going to write about how to read temperature using Micro:Bit.
  • How To Control Mini Servo With BBC Micro - BitMar 30, 2018. In this tutorial, I will show how can we control and drive Mini servo with BBC Micro: Bit.
  • Creating An Accounting Application With C#- Part TwoMar 27, 2018. This article is the second part of the series of Creating Accounting applications with C# Tutorial. If you didn’t read the first part, please have a look at it before continuing with this.
  • Azure Table Storage Design Manage And Scale Table PartitionsMar 23, 2018. In this tutorial, we will discuss the designing, managing, and scaling of Azure table storage partitions.
  • CRUD Operation In ASP.NET MVC Using Angular With Basics - Part TwoMar 22, 2018. In this article, we are going to create a Database and controller to perform CRUD operation using Angular.
  • Creating Accounting Application With C# Tutorial - Part OneMar 21, 2018. In this article, you will learn to create an Accounting Application with a C# Tutorial.
  • Pre-Deployment And Post-Deployment Script - SQL Database ProjectMar 20, 2018. In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.
  • Xamarin.Android - Chat Application Using Firebase - Part OneMar 19, 2018. Hello everyone, I am glad that you are here to learn some amazing stuff. In this episode, i shall show you how to make chat application with Firebase on Xamarin Android. This chat application is based on Firebase Auth and Firebase Database by using Xamarin.Firebase plugins.
  • Learn About SSMS Output WindowMar 17, 2018. In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually did respond and life was good again.
  • Building Real Time Applications With Firebase Database And AngularMar 16, 2018. Firebase helps us make development faster, so we can skip the development part where we build API and database objects like stored procedure.
  • Building A Data Driven App Using WPF XamDataGridMar 15, 2018. A typical rich data-driven Windows client app includes a backend database and a front-end client UI. The app connects to a database, reads the database, displays records in data controls, and implements CRUD operations. The app may also include some advanced UI operations such as sorting, searching, filtering, multiple views, and data export.
  • Setting Up Entity Framework Core Database With FactoryMar 14, 2018. In this write-up, I will explain how to easily and quickly set up your database using Entity Framework Core in a .NETCore project using the factory pattern to connect your entities to your database.
  • How To Insert Bulk Records Into SQL Server Using XML Data TypeMar 11, 2018. Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.
  • Continue With Learning Indexes In MongoDBMar 08, 2018. This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
  • Creating Stop Watch Android Application TutorialMar 08, 2018. Hello all! In this tutorial, we will learn how to create a Stop Watch android app, which will have basic features of a stop watch like, Start, Stop, Pause and Reset.
  • Table Splitting In Entity Framework Core 2.0Mar 06, 2018. One of the major benefits of the Entity Framework is that our entity model does not need to match our database model. With Table Splitting, it is possible to map multiple entities to the single database table.
  • Understanding Fragmentation In Distributed DatabasesMar 03, 2018. This article explains about fragmentation types in distributed databases.
  • No Tracking With Entity Framework CoreMar 02, 2018. DbContext in Entity Framework is responsible for tracking the changes made on the entity or object, so the correct update is done to the database when the SaveChange() method of context is called. When we retrieve entities using an object query, the Entity Framework puts these entities in a cache and tracks whatever changes are made on these entities until the savechanges method is called. Entity Framework tracks the query results that return entity types.
  • What Is Date Correlation Optimization?Feb 28, 2018. OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do a little research. Who knows, it may actual help me solve one of the many problems I run into day to day for clients.
  • New Features Of Entity Framework Core 2.0Feb 28, 2018. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This article explains about the new feature of EF Core 2.0.
  • Using NPoco ORM In ASP.NET CoreFeb 27, 2018. As you know, we have so many ORM available such as NHibernate, Entity Framework, Dapper.Net which are used to communicate with database in order to perform CRUD (Create, Read, Update, Delete), and also retrieving data based on criteria.
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • A Beginners Guide To Microsoft BizTalk Server - Part 1Feb 15, 2018. BizTalk Server is a middleware product from Microsoft that helps to connect various systems together. Let’s take an example: If you look at any modern organization it will run its operations using a variety of software products. SAP for their ERP needs, Salesforce for their CRM needs, Oracle for their Database needs, + tons of other home-grown system like HR, Finance, Web, Mobile etc.
  • Creating An Azure Database For PostgreSQL ServerFeb 11, 2018. In this article, I am going to demonstrate how to create a database in Azure for the PostgreSQL server in the Azure Portal.
  • Creating And Configuring A MySQL Server On The Azure PortalFeb 10, 2018. This article demonstrates how to create a MySQL database on the Azure Portal.
  • Database Naming Standards For The ProgrammerFeb 09, 2018. Let us face it, in most companies that programmers work for, we end up doing database work. I do not agree with this since I think the DBA or BIA should handle database programming and we should stick to what we do best… coding. Would you want a DBA writing code? I think not. With that said, here are database naming standards that I use when in this situation. DBA’s might not agree with how database coders name databases; stored procedures etc. but we need something.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Send E-Mail Android Application TutorialFeb 06, 2018. Hello all, in this article we will learn how to create an Android app which will send email using any email client. In this tutorial we are using the intent service of android which will help us to send email. Intent is very useful in android development as it helps us to call services which we need like calling, sms, gps, etc. It has a wider role in android.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • Boolean Search Basics For Recruiters - Tutorial OneJan 31, 2018. Boolean Search is a mathematical logic which we use to put on Google, LinkedIn, and other job boards etc. to get the accurate and relevant results while expanding and narrowing the strings with key operators like AND, OR, NOT etc.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • How To Add Excel Add-In For GeoCoding (Batch GeoCoding)Jan 27, 2018. This simple tutorial is about adding MS Excel Add-in and getting the geocodes, i.e., Location Points (Latitude, Longitude) or to verify the accuracy of address, using three Service Providers
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • Converting SQLite Database To Excel And Excel To SQLite Data In AndroidJan 23, 2018. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
  • ASP.NET Core Apps In Docker SwarmJan 23, 2018. First, we need a few Virtual Machines to make a cluster of machines to run Docker on. I am using Windows 10 and will use Hyper-V for this purpose. If you’re using another OS then skip the first part of the tutorial where I setup VMs.
  • Deploying Multiple ASP.NET Core Apps To Docker And AzureJan 22, 2018. API - has controller with CRUD operations for a movies database. It uses a class library Data, which contains repositories. Database is hosted in Azure and connection string stored in application settings (appsettings.json).
  • Database First In .Net Core 2.0 CRUD Operation - Part OneJan 17, 2018. In my previous post, I have explained how to create an Angular 5 application in Visual Studio 2017 using .NET Core templates which you can find here.
  • MVVM Databinding In Xamarin.Forms Using Fresh MVVMJan 16, 2018. In this tutorial, we will learn how to perform MVVM approach in Xamarin.Forms using Fresh MVVM.
  • Angular 5 CRUD Operation Using Node, Express, MongoDBJan 13, 2018. In this article, we’ll learn to create basic CRUD application using angular 5, Nodejs, Express and Mongodb nosql database.
  • Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQJan 12, 2018. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET MVC from database using linq.
  • Pin Coordinates To External Maps In Xamarin.FormsJan 08, 2018. In this tutorial, we will learn how to pin Latitude and Longitude Coordinates in External maps in Xamarin.Forms. The Coordinates are pinned with Google Maps in Android and Apple Maps in iOS.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Voice 2 Text Android Application TutorialJan 06, 2018. Hello all, in this article we will learn how to create an Android Voice2Text App. So by the app name we can understand what we will be going to make. In this app Voice2Text, user voice will be converted into text and will be displayed in the input field. Voice2Text App does not need any internet connection it will work offline.
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • Welcome To CSS / CSS3 Tutorial Series - Part OneJan 03, 2018. In this series you will learn about property-wise.
  • Using jTable Grid With ASP.NET MVCJan 03, 2018. In this article, we are going to learn how to use jTable Grid with ASP.NET MVC, and along with that we are going to use Entity framework for accessing the database.
  • Optical Character Recognition Using Google Vision API On AndroidJan 02, 2018. In this tutorial, we will learn how to do Optical Character Recognition in Android using Vision API. Here, we will just import the Google Vision API Library with Android Studio and implement the OCR for retrieving text from image.
  • Getting Started With Q# Programming Jan 01, 2018. In this tutorial, you’ll learn how to build your first simple “Hello World” Q# app. Just follow these following steps.
  • Xamarin.Android - Working With Recycler ViewDec 30, 2017. In this tutorial, we are going to learn how to render a simple RecyclerView with a custom layout
  • Create Event Calender In LaravelDec 28, 2017. In this tutorial we will learn the implementation of Full Calender (Javascript Event Calender) in Laravel.If we want to show our events,tasks & schedules along with the start time and end time then we have to use 'fullcalender jquery plugin' in our Laravel Application.
  • Creating A CRUD With ASP.NET Core And EF CoreDec 28, 2017. Entity Framework Core (EF) is an ORM that makes it simpler to work with database by using POCO classes that map to database entities and DbContext to interact with them.
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • Image Classification In iOS Apps Using Turi Create And CoreMLDec 22, 2017. These days the hype for Machine Learning is real. Everyone just wants a piece of it in their product development. Let it be a spam filter or just a cookie machine. That being said, the demand is undoubtedly high. True. But another fact that is true is that not everybody can just go in all guns blazing and develop intelligent systems. It requires shenanigans with specialized knowledge to actually create and train and make a system mature. You can follow the tutorials online but they just go over the top of the bun and never give you an idea that the patty is drier than the Sahara Desert.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Using Gijgo Grid With ASP.NET MVCDec 20, 2017. In this article, we are going to learn how to use Gijgo Grid with ASP.NET MVC along with that we are going to use Entity framework for accessing the database.
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.
  • Building Multitenant Architecture Using ASP.NET Core And Micro ServicesDec 18, 2017. Instead of deploying an application per client, organizations prefer multitenancy to save infrastructure cost and deployment time. Multitenant architecture helps to adapt changes for different clients under the hood. In this article I am not going to discuss database design for multitenant applications but I will be focused on achieving separation for different clients.
  • Xamarin.Android - SQLite DatabaseDec 17, 2017. In this article, I shall show you how to handle all database CRUD operations using SQLite.
  • Xamarin Android - Working with Existing DBDec 16, 2017. In this article, I shall show you how to retrieve user data from existing SQLite Database.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • Getting Started With CosmosDBDec 12, 2017. DocumentDB is a NoSQL database which is massively scalable and it works with schema free JSON documents.
  • Starting With Google Cloud Firestore Database With AngularDec 12, 2017. Cloud Firestore is a NoSql Document database built for automatic scaling, high performance, real time, and ease of application development.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Building An ASP.NET Core Application With Web API And Code First DevelopmentDec 05, 2017. In the previous article, we’ve learned the high-level overview of what Entity Framework is all about and learned how to build a web application quickly using Entity Framework’s Database-First development.
  • View Product Details Using Kendo ScrollView In ASP.NET MVC5 With Entity FrameworkNov 29, 2017. Here, I will demonstrate how to work with Kendo ScrollView to View the product details from a database using Entity Framework in ASP.Net MVC5
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • Connecting R Software With Oracle DBNov 24, 2017. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
  • Xamarin.Android - Working With MongoDBNov 21, 2017. Today, I will show you how to create MongoDB and how to use MongoDB using Xamarin.Android.
  • Implement DropDown MultiSelect Using Kendo UI MultiSelect In ASP.NET MVC5Nov 21, 2017. In this article, I am going to explain how to bind the value to a dropdown from the database, how to implement drop-down multi-select, how to group the drop-down values, and how to implement Custom Template using Kendo UI MultiSelect in ASP.Net MVC5.
  • Migrate From TFS To VSTSNov 21, 2017. Migrate from TFS to Team Services with the TFS Database Import Service.
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Uploading, Validating, And Storing A File Into Database Using EF In ASP.NET MVC5Nov 20, 2017. Here, you will learn how to upload a file, validate a file and store a file into database using JQuery, Entity Framework in ASP.NET MVC5
  • Monitoring S3 With Events And SNSNov 16, 2017. This is Muhammad Habib Jawady in a new DevOps hands-on tutorial. In my first Amazon Web Services tutorial, I will be showing you how to leverage the S3 events feature and Simple Notification Service In order to monitor actions taken on certain assets .
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Building A Questionnaire Site With Node.jsNov 14, 2017. This was our first project with Node.js, and by God, it was a pain. Node.js is an excellent framework, with blazing fast speed, and an intuitive development framework. For those who are familiar with HTML, CSS and JavaScript, Node.js is one of the best alternatives to PHP, ASP.NET or other server-side scripting languages that require a language to be learnt. Node.js is light-weight, resilient and community-led and in-development framework. This article is primarily focused on teaching the beginners in Node.js development. You can expect to learn a few basics of Node.js setup, how to manage the databases in Node.js environment and a bit more (less too, maybe).
  • MVC : Display Image From Byte ArrayNov 14, 2017. In this tutorial, I am going to explain how to display image from a byte array in ASP.NET MVC using C# .NET and VB.NET.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • Get Your Hands On Entity Framework Code First Workflow With New Database And Existing DatabaseNov 10, 2017. In this article we are going to learn how to create code first workflow with new database and existing database.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • MS Visual Studio Code - Guide To GitNov 06, 2017. Hello guys again, this is Muhammad Habib Jawady and today I will be showing you how to use MS visual Studio Code in order to work with git properly. This will be a hands on tutorial, I hope you will find this useful as the number of users of ‘Code’ has grown dramatically throughout the year and the need for a full tutorial on how to use it has became an urge to help people master its enormous number of features.

About jsp-database-tutorials

NA
Hire a remote developer
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now