C# Corner

Resources  
  • Basic Introduction To Power BIOct 17, 2017. In this article I will discuss the fundamental concepts of Power BI. So this article will cover basic knowledge on power BI, the need of power BI, the importance of data visualizations, the components of Power BI, the architecture of Power BI, the building blocks of Power BI & the cost of power BI tools.
  • Power BI - Get Data From SharePoint List / LibraryOct 16, 2017. In this article, we will explore two methods to get data from SharePoint List / Library in Power BI.
  • Get To Know The New Microsoft SharePoint Migration ToolOct 13, 2017. For many years SharePoint Migration has been a very challenging task for all the SharePoint professionals as it really requires a lot of planning, assessment and careful implementation to ensure that the data remains secure and it doesn’t get missed during the migration.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • 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.
  • ASP.NET Core 2.0 CachingOct 12, 2017. Caching frequently used data can improve the performance of a web application. For applications hosted on multiple servers, using distributed caching means the application can access data regardless of the instance server. Caching should be considered an alternate to using Session State.
  • 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.
  • Linked List Implementation In C#Oct 09, 2017. In this article, I will discuss one of the most important Data structures- Linked List.
  • ASP.NET Core 2.0 Session StateOct 09, 2017. Using an empty project from a previous post, amend Startup class ConfigureServicee() method, and add services for session and its backing store.
  • How To Connect Facebook to Twitter With Microsoft FlowOct 08, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one place and do something with the data from that event in another one service.
  • Managing Virtual Machine DisksOct 08, 2017. In this article, we will see how to add additional data disks and scale existing in a Virtual Machine.
  • ASP.NET - Connect To Azure Cosmos DBOct 07, 2017. This article will show how to configure and use CosmoDB on an ASP.Net MVC web application, The tasks will be stored as JSON documents in Azure Cosmos DB.
  • How To Implement Dependency Injection In MVC ProjectOct 07, 2017. Here I am going to explain how to implement dependency injection in MVC Project in detail including separate layers for getting data through Services and Repositories.
  • 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
  • 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.
  • Create Power BI Report Using Twitter AnalyticsOct 04, 2017. In this article, we will learn how we can use Twitter analytics data and prepare Power BI Report. We can export Twitter analytics data in .csv format and consume that .csv file to prepare a Power BI report.
  • 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.
  • 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.
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Create Value Object In C#Sep 28, 2017. Create a class that abstracts away (encapsulate) ‘data’ in your domain and provide methods to work on it. Below is a class I don’t consider a good Value Object.
  • What's New In Entity Framework Core 2.0Sep 27, 2017. Entity Framework Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework data access technology. Entity Framework 2.0 is the latest release of EF.
  • XAML Value Converter With A Simple ExampleSep 27, 2017. In this article, I'm going to show you how you can use value converter in XAML to convert one format of data into another format. In our case, we'll convert a string value (value in the textbox) to a Boolean value (checked status of a checkbox).
  • Consume Local File System As A Data Source In Power BISep 27, 2017. We all know Power BI is a very good business intelligence tool. Sometimes there is a situation when we need to prepare report using file system. Power BI provides a connector to consume data from folder structure. We can get all files from a specific folder. But there is one limitation with this connector.
  • 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.
  • Understanding Cloud Storage In AzureSep 26, 2017. In this article, I will explain about Storage Accounts (Storage Accounts can hold hundreds of terabytes of data.) and we will see how we can use Azure Storage as a place to keep uploaded files for our web application and how we can allow users to download files from storage by creating and handling out what is known as a shared access signature (SAS).
  • Local Data Caching In ASP.NET Web ApplicationSep 24, 2017. In this article, you will learn some solutions about local data caching in ASP.NET Web Application .
  • Stored Procedure With Input And Output Parameter Using Entity Framework In ASP.NET MVCSep 23, 2017. In this article, we are going to learn how to get list and output value from a stored procedure using Entity Framework in ASP.NET MVC.
  • Edit Or Remove Permission From Existing Data Source Connection From Power BISep 23, 2017. In this article, we will learn how we can remove our existing data source connection from Power BI Desktop.
  • Data Binding In XAML UWP Using ComboBoxSep 22, 2017. In this article, we'll learn about Combo Box Control in XAML and data binding of this control as well in UWP Applications.
  • How To Implement Angular Data Table With CRUD Using ASP.NET MVC And AngularSep 22, 2017. In this article, we will discuss how to implement Angular Data Table with (Insert, Update, and Delete) Short Form (CRUD) using Asp.net MVC + Angular JS in one page without any full page reloads. This table will be similar to JQuery Data Table and this one is implemented using Angular Data table.
  • Store Photo In Backend Using Entity Framework In MVC Razor And BootstrapSep 21, 2017. Here i will show you image details will be shown along with user name. This one a sample exmaple of student management system In mvc and bootstrap.
  • Basic PDF Export Using JQuery In ASP.NET MVC RazorSep 21, 2017. Here i will show you after insert records how to export the record in pdf format using jquery.
  • How To Create WebAPI In ASP.NET MVC With C#Sep 21, 2017. This article demonstrates how to create and use an insert update and delete record using Web API in MVC with C# technology
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Store Images In App Directory In Xamarin iOSSep 21, 2017. In this article, you will learn how to store images in the App Directory in Xamarin iOS, using Xamarin Studio.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • 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.
  • Create Immutable Type In C#Sep 14, 2017. A public constructor that accepts initialization data is required so that the client can pass-in minimum state for the type to be valid. Private constructor, on the other hand, is used by methods to construct a new object and set its entire state.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • 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).
  • ASP.NET Core 2.0 ConfigurationSep 11, 2017. ASP.NET Core has a simple mechanism to read application settings from various sources like JSON files, Environment variables or even custom data sources. It is also simple to use the settings, thanks to Dependency Injection.
  • Frequent Pattern And Market Basket ImplementationSep 09, 2017. Frequent pattern mining is about the item sets and sequences which appear in a data set.
  • Data Science Machine Learning In R ProgrammingSep 09, 2017. In this article, I am going to describe what machine learning and data science are and then we will see how we can apply machine learning techniques in data science and then we will do some practical implementations in R language of data pre-processing.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Data Mining And Market Basket ImplementationSep 08, 2017. This article talks about the major techniques which are used in data mining to extract raw data for the following steps like data cleaning, data pre-processing, etc. and constructing useful datasets which are used for prediction.
  • 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.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • 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.
  • 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.
  • Use Wikipedia As A Data Source To Prepare Power BI ReportSep 07, 2017. Power BI is a business intelligence tool. It supports so many data sources to prepare a report. As we all know Wikipedia is a very good resource of useful information. We can consume Wikipedia data as a data source and prepare a Power BI report.
  • 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 Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • Understanding Bot Service In AzureSep 06, 2017. This article will give an overview about the MS bot framework. Open azure portal and click on add and choose category “Data + Analytics” and then select the option “Bot Service”.
  • The Basic Concepts Of Data ScienceSep 04, 2017. The basics concepts of data science can be separated two important parts. Maybe some people can argue with me because I have to tell you supervised learning and unsupervised learning and decision trees algorithms. But my intend is not explaining the concepts of Data science. This article is related to some knowledge about who wants to be started as data scientist.
  • Search Data From Xamarin.Forms List ViewSep 04, 2017. In this article, we are going to search some data from list view of xamarin forms. Firstly we can create a list in xamarin forms PCL application. Then add some data in list and make a search bar to search data form list.
  • What Is Meant By Big DataSep 04, 2017. Big data is a term that describes the large volume of data - both structured and unstructured - that overload a business on a day to day basis.But it's not the amount of data that's important.It's what all the - organisations do with the data that matters big data can be analyzed for insights thats load to better decisions and strategic business moves "Big data" is similar to "small data",but it is bigger in size.Big data is the collection of both structured and unstructured data which are from different sources like social data,machine generated data and traditional enterprises.
  • 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 Perform CRUD Operation Using JSON File With Sorting And Paging In Angular - Part TwoSep 02, 2017. Today, in this article, I will explain performing CRUD operations in Angulars j. In my previous article I have retrieved records from json files with sorting and paging in. Now I will explain how to Insert, Update and Delete in angular js, and also with required filed validation. So let us go through step by step.
  • Display Office 365 Data Using MS Graph API In Power BISep 01, 2017. In this article, I will show how you can display Office 365 data of your organization in Power BI report using MS Graph API. I will show how you can fetch your organization’s users with MS Graph API, and quickly create a report using Power BI Desktop. Once you learn to use MS Graph API in Power BI, you can explore more options to create some interesting reports on your own.
  • 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.
  • Manage Paths Of Web Applications In SharePoint 2016 Central AdministrationAug 29, 2017. Here, you can include a new path to your web application or insert it through explicit or wildcard entries. This helps you to decide what will be the path of creating websites in the site collection.
  • 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.
  • Learn About Azure Mobile ServicesAug 28, 2017. Azure mobile app service provides high scale functionality of azure app services to add sign -in, push notifications, data sync and many more. It also helps us to connect your app to many Enterprise systems. It provides a scale up facility for many customers across multiple geographies.
  • New in Machine Learning - An Intent Based Network ManagementAug 28, 2017. Implementation and application of Machine Learning are growing rapidly across different industries. The next big thing is Intent-Based Network or IBN.
  • Data Structures and Algorithm (DSA) – Performance, Complexity And Big-O NotationAug 28, 2017. In this article we will be talking about what performance of an algorithm is and how Complexity is used to measure performance and what Big-O notation is.
  • Use SharePoint Online List As A Data Source In Power BIAug 26, 2017. In this article, we will check how we can use SharePoint list as a Data source in Microsoft Power BI.
  • 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.
  • Accessing Microsoft Graph Data Using Azure AD Authentications From SPFxAug 24, 2017. Let us see how to call Microsoft cloud data using Azure Active Directory authentications from SharePoint framework components.
  • Virtual Machine Scale SetAug 23, 2017. Virtual Machines are highly flexible such that they can be changed in their size and the performance based on the requirement of the user. The resources which we actually require can be decided by us and then the user can be able to scale up or down the Virtual Machine. When making changes to the Virtual Machine size, the cost that is charged for the Virtual Machine will also vary. Here the size of the Virtual Machine will include the number of cores, the Random-Access Memory, number of data disks, the IOPS range, SSD size, load balancing feature and premium disk support.
  • REST CRUD (Insert,Update,Delete,Get) Operations Using SharePoint Hosted App - Office 365 - Part OneAug 22, 2017. SharePoint adds the ability for you to remotely interact with SharePoint sites by using REST. Now, you can interact directly with SharePoint objects by using any technology that supports standard REST capabilities.
  • 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.
  • Getting Started With Microsoft Azure Machine Learning - Part OneAug 19, 2017. It’s a data modeling environment from which we can get an end-to-end approach to a problem to an answer. Use Azure Machine Learning to deploy your model into production as a web service in minutes—a web service that can be called from any device, anywhere and that can use any data source.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Custom Model Binding In ASP.NET Core MVCAug 17, 2017. Model binding in MVC maps HTTP request data to the parameters of the controller's action method. The parameter may either be of simple type like integers, strings, double etc. or complex types. MVC binds the request data to the action parameter by parameter name.
  • Understanding Media Services In AzureAug 17, 2017. Azure helps you to build custom media workflows in the cloud. It’s an end-to-end solution that delivers audio and video virtually in any device anywhere. It offers end-to-end workflow which is very highly scalable in coding, packaging, storing and distribution of media content to a wide range of devices including TV, PC, and mobile devices.
  • 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.
  • Configuring Azure AD With App Permissions For SharePoint REST API AuthenticationsAug 15, 2017. Let us see how to setup the Azure Active Directory with necessary app permissions for accessing the Microsoft data using graph API.
  • CRUD Operation With JSON File Data In C#Aug 15, 2017. This article will demonstrate how to implement CRUD functionality with JSON file in a project using C# code.
  • Consuming Restful Services In Xamarin.Forms - Part TwoAug 14, 2017. In the first part, we called a fake RESTFul service, got some data from the service, and displayed it in a list view. Now in this article, we will continue where we left and add, delete some data which we displayed in previous part.
  • Creating A Data Volume In Windows PowerShellAug 12, 2017. We shall now try creating a data volume which can be used by more than one container images.
  • IoT Solutions - Architecture/Design And Business AspectsAug 11, 2017. IoT is the abbreviated term meaning "Internet of Things". By definition Internet of Things is: the inter-networking of physical devices, vehicles (also referred to as "connected devices" and "smart devices"), buildings, and other items embedded with electronics, software, sensors, actuators, and network connectivity which enable these objects to collect and exchange data.
  • Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
  • Data Structures In Java - Linear ArrayAug 10, 2017. Data structure means organizing the data by using models in the computer memory. A linear data structure that represents a relationship between elements by successive memory location is known as the array, where as a linear data structure that represents a relationship between elements by pointer and link is known as linked list.
  • How To Do Paging With ASP.NET Web APIAug 10, 2017. In this article, we are going to learn how to do paging with Web API. In this modern era where there are tons of data to share and consume here we cannot send all data at one go or consumer we need to slice the data into pieces to share known as paging.
  • Understanding Azure Mobile ServicesAug 09, 2017. This article will give you an idea about the Azure Mobile Services. It allows the functionality of Azure App Service to add sign-in, push notifications, and data sync to your mobile app. Connect your app to enterprise systems and on-premises resources.
  • 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.
  • Passing Data To AWS Lambda Function And Invoking It Using AWS CLIAug 09, 2017. In previous article, we learnt about AWS lambda structure and how a lambda function can be invoked. Before we go further, there are couple of things which are very important to consider while doing local development and production deployment.
  • Overview Of Azure Data LakeAug 09, 2017. In this article, we will walk through some important concepts of Azure Data Lake and its implementation.
  • Using Category To Store Your Master DataAug 08, 2017. In every CRM implementation, we deal with some sort of master data in CRM. Normally we use the traditional way to store master records by creating custom entities. But we do have a better way to store master data using Category entity.
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • 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.
  • Making Web Sites Look Like Native Apps Without the App StoreAug 02, 2017. Earning a place on a user's home screen is key to engagement with customers. The automatic Add to Home Screen Experience provides this capability to progressive web applications. This is driven by the web manifest file, providing valuable meta information to the browser.
  • Angular, Bootstrap And ASP.NET MVC - Part Seven (Bootstrap Modal Forms)Aug 02, 2017. In previous articles, we have learned AngularJS project setup, styling with bootstrap, AngularJS structure, data-binding, routing, copying of angular object when form is saved or cancelled, inserting/updating forms, etc.
  • Selecting An Enterprise Content Management System (CMS) - Part TwoJul 31, 2017. In continuation of my previous article on – “Selecting a Content Management System that supports Your Business”, I thought of writing this article on selecting an Enterprise CMS. Nowadays, Mobile, Big Data and E-Commerce are causing drastic changes in the business landscape and all those companies who ignored their online presence are at the risk of losing customers and revenue.

About Insert-Data-with-Stored-Proc

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!