C# Corner

Resources  
  • 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.
  • 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.
  • 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.
  • 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.
  • 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
  • Convert XML File To Excel FileNov 27, 2017. Here, we are going to learn to read XML files in C# WindowsForm applications. We are going to make a small single-form application which takes an XML file from the user and convert XML Data to Excel Data and Returns an Excel File.
  • 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
  • Creating CRUD API In ASP.NET Core 2.0Nov 17, 2017. ASP.NET Core gives a unified mechanism for creating MVC and Web API application. The key difference is that Web API will return JSON (or XML) and HTTP status codes instead of views, in order to communicate with the client.
  • Create App Using Xamarin.Android Using C# - Part FourNov 17, 2017. Xamarin.Android has native user interface controls. These controls can be easily added to Xamarin.Android apps using the Android Designer or programatically via XML layout files. Xamarin.Android exposes all of the user interface object properties and methods in C#.
  • 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).
  • 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.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • Getting Started With Azure Cosmos DBOct 29, 2017. Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with a comprehensive SLA. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.
  • Cloud Databases In Azure - Part ThreeOct 24, 2017. This is the third article in the “Azure Cloud Databases” articles series, which is in continuation of the previous two articles.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
  • Getting Started With Entity Framework Core - Database-First DevelopmentOct 12, 2017. This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core. We will explore the database-first approach and see how models are created from an existing database. We will also take a look at how classes become the link between the database and ASP.NET Core MVC Controller.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Logging Exception in Database Using CustomFilter ExceptionOct 11, 2017. As per request from one of my followers I am writing this article, which will explain how we can handle Errors in an MVC application. In this article I am also going to explain how we can log our exception message in our Data Base.
  • Cloud Databases In Azure - Part OneOct 11, 2017. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e. PaaS side of Microsoft Azure.
  • How To Use DataList Control In ASP.NET With Example in C#Oct 08, 2017. In this article I’ll present a tutorial with an example, a way to use the DataList control in Asp.Net for the displaying of information/ records from the database with using SqlDataSource.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • Xamarin.Forms - Create MVVM Data Binding Application Oct 07, 2017. Xamarin Forms Platform using Create MVVM Data Binding application using xml and c# code
  • How To Change/Switch The Database Dynamically In An ASP.NET MVC ApplicationOct 06, 2017. This is an example with code snippets to show how to switch or change the database (Connection string) dynamically while running a program in ASP.NET MVC 5 applications.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part OneOct 06, 2017. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need to identify an encryption approach that best suits the requirement. I'm going to share my experience in finding the encryption approach and implementing it on a sample database.
  • How To Log Messages (Information, Errors, Warnings) In ASP.NET CoreOct 04, 2017. Framework provides logging capability through ILoggerFactory, to which you could attach one or more providers. Providers act on the logged data in some form i.e., log it to file, database, Azure etc.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • Azure NoSQL In ASP.NET Core 2.0Sep 26, 2017. The sample code will require you to set up an Azure account, NoSQL database and collection.
  • How To Create To-Do CRUD Operation With ASP.NET MVC Core, Angular 4.0Sep 21, 2017. We want to create below single page application with CRUD operation, Add, Update and Remove functionality with in-memory TodoRepository Database.
  • SQL Server DB Backup Using Stored Procedure In WinForm ApplicationSep 14, 2017. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
  • How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).
  • Kickstart Azure Database For PostgreSQLSep 10, 2017. This blog post will walk you through creating an Azure Database for PostgreSQL in Azure Portal. PostgreSQL is a powerful, open source object-relational database system and has capability to handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Azure Database for PostgreSQL is a managed service which enables you to run, manage, and scale PostgreSQL databases in the cloud.
  • Frequent Pattern And Market Basket ImplementationSep 09, 2017. Frequent pattern mining is about the item sets and sequences which appear in a data set.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Where Can I Use Common Azure CosmosDB (Use Cases)?Sep 06, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service for managing data at planet-scale. It builds upon and extends the earlier Azure DocumentDB which was released in 2014.
  • How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • Async Validation In WPFAug 31, 2017. Quite often validation requires web requests, database calls or some other kind of actions which require significant amount of time. In this case, UI should be responsible during the validation, but saving/submitting data should be disabled until validations completion.
  • Getting Started With MongoDBAug 29, 2017. MongoDB is an open-source/cross platform (Windows, Linux, etc) document database that is NoSql in JSON format database. A NoSQL database means it does not have any relationships (non-relational database). It is a document-oriented database.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • Availability Of Azure Database For MySQL And Azure Database For PostgreSQL In IndiaAug 26, 2017. In Indian data centers (Central and West India), the public preview of Azure Database for MySQL and Azure Database for PostgreSQL are available. And their services provide app developers the ability to choose from an even wider number of geographies, and deploy their favorite database on Azure, without the complexity of managing and administering the databases.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service "for managing data at planet-scale." It builds upon and extends the earlier Azure DocumentDB, which was released in 2014. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • Building A Simple Web App Using Razor PagesAug 23, 2017. In this article , you will learn how to build a simple CRUD web app using Razor Pages , which is new in ASP.NET Core 2.0. This web app is about the management of the students , and all operations of the database will be through API building by NancyFx.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Understand Azure Cosmos DB - Table APIAug 18, 2017. Cosmos DB is a globally distributed multi-model database. Using the API, applications running on Azure Table storage can take advantage of secondary indexes, turnkey global distribution, dedicated throughput, and single digit millisecond latency with 99.99% comprehensive SLAs.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • Key Capabilities Of Azure Cosmos DBAug 12, 2017. A few years ago, Microsoft offered DocumentDB as a Service (DaaS) that supported a limited set of features and functionalities. Today, most of the cloud-based services, such as Bing, Azure, and Office 365 are using DocumentDB. Microsoft took DocumentDB to the next level and came up with Azure Cosmos DB - A globally distributed, multi-model database.
  • Accessing XML Data From XML Document In C# Console ApplicationAug 09, 2017. In this article, I am going to give the best way to access XML data from XML document and also how to find common record node counts.
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • Understanding DocumentDB In AzureAug 08, 2017. This article will give you a feel for Azure DocumentDB. It is a NoSQL document database service designed from the ground up to natively support JSON and JavaScript directly inside the database engine.
  • Dependency Injection - Part One -Tightly Coupled ApplicationAug 07, 2017. It is a best practice to use interfaces instead of concrete classes. These interfaces can then be mocked at the time of unit testing, which will prevent any call to the actual database. Also, it is a good practice to stop "newing-up" objects in classes.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • Statistics And Cost Estimation Internals - Part OneJul 30, 2017. Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look deep inside Statistics.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Entity Framework Core Triggers In Action (Unofficial Package)Jul 24, 2017. This article shows you how to work with database triggers in Entity Framework Core using a third party library.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Creating C# Wrapper Over Firebase API For Basic CRUDJul 17, 2017. Firebase is a platform provided by Google, which provides many services. Firebase Realtime Database is one of them. Firebase provides many SDKs for different platforms as well as it provides REST API to interact with database. Here we will build wrapper in C# around REST api to easily perform CRUD operations in our C# applications.
  • Best Practices For MVCJul 14, 2017. Add a class library project to the solution, named Store.Model. This library is where we ‘ll keep all of our domain objects. Entity Framework will count on them in order to build the database but we are not going to configure Code First using DataAnnotations attributes on this project. Instead, we are going to put all the Code First configuration in specific Configuration classes using the Fluent API. Add a folder named Models.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • Creating A Database-Driven MVC Image Gallery With ThumbnailsJul 12, 2017. MVC Image Gallery, Save Image in a database, Retrieve Images from a database, Create Image thumbnail from the database, Upload Image through Ajax, Fancy Box Gallery
  • Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
  • How To Upload Records From Excel File to Database Using Stored Procedure In MVCJul 10, 2017. In this article, I will explain how to upload records from Excel files in the database using store procedure and also how to check all types of validation.
  • Getting Started With MongoDB - MongoDB In Azure Cosmos DBJul 10, 2017. My last article demonstrated how to interact with the MongoDB database server from a simple C# console application. Now, when you build enterprise applications using MongoDB, your local database server should always be up and running for 365 days or more. This is not appropriate for enterprise applications.
  • Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
  • Overview Of MongoDBJul 04, 2017. This article explains the basics of MongoDB, doing CRUD operations on it using command prompt and then CRUD operations with a sample ASP.Net WebAPI.
  • Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
  • Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
  • Setting Up SQLite In Xamarin.FormsJul 03, 2017. In this article, we will learn to set up SQLite in xamarin.forms. It doesn’t require too much time and it is not difficult like setting up other databases.
  • Creating TreeView For MVC 5Jul 03, 2017. We're going to extend JsTree from JS to MVC and we'll render HTML tags from the database using custom development in the model.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • How To Create Azure SQL Database And Access It Through Visual Studio CodeJun 26, 2017. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
  • Daily Shrink Database Log Automatically Using Jobs In SQL ServerJun 24, 2017. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script manually.
  • Working With XML In Windows PowerShellJun 23, 2017. In this article, you will learn about XMLs In Windows PowerShell.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
  • Database Driven Development And Developing The User Interface Using C#Jun 21, 2017. In this article, I am going to explain about Database Driven Development and Developing the User Interface Using C#.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.

About Xml-Database

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!