C# Corner

Resources  
  • Working With OleDb Data Adapters Jun 19, 2001. This step by step tutorial guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Generating XML from SQL databaseJul 30, 2001. Some Days Back i posted the article dealing XML as a Middle tier but i guess the People didn't get the clear funda.
  • Create a SQL Server Database dynamically in C#Mar 05, 2002. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table schema programmatically. You’ll see how SQL statement ALTER TABLE is useful when you need to change a database table schema programmatically.
  • Creating Graphics with XMLApr 09, 2002. This article shows how to create images on the fly and uses XML to specify the properties of the images.
  • XML Schema ValidatorApr 16, 2002. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model.
  • Changing User Information using Active DirectoryAug 14, 2002. If your company is one of the lucky? Ones to implement Windows 2000 Active Directory you may have been looking for a way to populate it with data. Perhaps adding people’s details from a file directly into the active directory.
  • DataSets in Microsoft .NETFeb 20, 2004. ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework.
  • SOAP Client in Windows XPMay 06, 2004. This article covers the basics of using the SOAP Client software included with Microsoft Windows XP Professional to access Web Services using SOAP.
  • Validating Input Xml Data FilesJun 28, 2004. In this article we'll discus two strategies for validating input XML data files. The validation of an XML input file could occur at various instances of processing.
  • Retrieving Schema Information Using ADO.NET and C#Jul 06, 2004. In this article, I will describe the ways to retrieve the database schema information using System.Data.SqlClient class and the System.Data.OleDb class.
  • In-depth Look at WMI and Instrumentation: Part ISep 14, 2004. WMI provides a consistent programmatic access to management information in the enterprise. It uses the typical provider and consumer concept where you have on one side components providing this management information while on the other side management applications can subscribe and consume it.
  • CopySchema - Part 2Oct 05, 2004. CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema.
  • TranslateSQLOct 05, 2004. TranslateSQL is a utility for generating SQL-Server SQL scripts based on an existing Oracle schema, in essence 'translating' Oracle schemas into SQL-Server databases.
  • CopySchemaOct 05, 2004. CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema.
  • Leveraging on XML feature of Microsoft Office Word 2003Nov 24, 2004. Word 2003 came up with a new feature of saving the conventional word document (.doc) files in the XML format. You can retrieve the information inside the Word 2003 documents by using the XPath queries and some logic.
  • Data Access Layer to execute Stored ProceduresJan 18, 2005. This article explains about executing a single stored procedure or batch of stored procedures from the application layer. As Data access layer completely decoupled from Application layer we just need to change the Application layer in case of any change in underlying database schema.
  • Best Approach for Designing Interoperable Web ServiceMar 15, 2005. This article will clarify and explain in detail the different Web Service Design Methodologies as defined by the Web Services Standardization Groups, clarify the terms, highlight their differences.
  • Using Snippets in Visual Studio 2005Nov 10, 2005. Visual Studio contains several built-in intellisense code snippets. Snippets are like templates and can be described completely in XML. If you understand the snippet xml schema, you can easily begin to create your own snippets.
  • How to Execute Oracle Stored Procedures Dynamically in C# Nov 10, 2005. In this article, I wiil show how we can store schema of stored procedures in an XML file and load and run the stored procedure from UI application using C# and Oracle.
  • Using XML and XSLTJan 18, 2006. XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats. This article shows how to perform the transformation using classes of .NET Framework.
  • View database structure using C#Jan 16, 2008. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • Biztalk Messaging Services: Flat File SchemaJan 21, 2008. This article is intended to consolidate the principles of messaging in Biztalk Server 2006.
  • Biztalk Messaging ServicesMar 27, 2008. This article is intended to illustrate the concepts of mapping in Biztalk Server 2006.
  • Best Practices for Data Transfer in SQL Server 2005Jun 23, 2008. This article talks about some best practices and the process of data transfer in SQL Server 2005.
  • Create a SQL Server CE Database From SQL Schema FileMar 04, 2009. In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
  • Promoting Schemas Properties in BizTalk ServerMar 18, 2009. A common scenario in a BizTalk solution is to subscribe to a message based on its content or context and make decisions based on the underlying values. This is known as content-based routing. In this article, I will cover the principles and techniques to expose this sort of metadata in BizTalk Server.
  • Parsing BizTalk Messages in .NET Components Through OrchestrationApr 30, 2009. This article discusses how to parse BizTalk messages in .NET Components through Orchestration.
  • Receiving Messages With Multiple Schemas in a Single OrchestrationSep 18, 2009. In this article, I will cover how to receive two messages with different schemas in a single orchestration in order to process them instead of creating separate orchestrations for each message with identical business logic. For the solution, I will use the Listen shape along with two Receive shapes each of them listening for different messages.
  • XML NamespacesNov 18, 2009. In this article I will explain you about XML namespace, DTD and schemas and Extensible Hyper Text Markup Language.
  • Standardizing Incoming Messages Using Inbound Maps Tab on Receive Port Properties in BizTalk ServerNov 25, 2009. In this article we will see how to develop integration applications which receive documents with different schemas arriving from external entities, and it’s required to transform each format to a common (canonical) internal schema using port maps on the receive ports in BizTalk Server.
  • Visual Studio .NET and XML SupportDec 02, 2009. In this article I will explain you about Visual Studio .NET and XML support.
  • Working with DataSetsDec 04, 2009. In this article I will explain about working with DataSets.
  • Adding Typed DataSets in ADO.NET Dec 13, 2009. In this article I will explain about Adding Typed DataSets in ADO.NET.
  • Using the Data Form Wizard in ADO.NETDec 17, 2009. In this article I will explain about using the Data Form Wizard in ADO.NET.
  • Creating a Guest Book in ASP.NET Jan 29, 2010. In this article I will explain Creating a Guest Book in ASP.NET.
  • Getting a Database Schema Mar 11, 2010. In this article I will explain getting a Database Schema.
  • Compare Two XML Files Using .NetMar 23, 2010. In this tool, we Validate the schema and compare the data's of two XML files.
  • Validation in Linq to SQL and ASP.NETMay 19, 2010. In this article, I will show how to add business rules to Linq to SQL data model default set of schemas.
  • Model-First Design using ADO.NET Entity Framework 4.0 Jul 19, 2010. In this article we are going to see the second most importment part of the ADO.NET entity framework 4.0.
  • Schemas in SQL ServerOct 18, 2010. Schemas are nothing but logical grouping of objects either it may be a table or view or stored procedure or function or any other DB objects.
  • Chapter 3: Data-Tier ApplicationsNov 30, 2010. With the release of Microsoft SQL Server 2008 R2, the SQL Server Manageability team addressed these struggles by introducing support for data-tier applications to help streamline the deployment, management, and upgrade of database applications. A data tier application, also referred to as a DAC, is a single unit of deployment that contains all the elements used by an application, such as the database application schema, instance level objects, associated database objects, files and scripts, and even a manifest defining the organization’s deployment requirements.
  • SQL Server Schema Comparison in Visual Studio 2010Mar 05, 2011. This article explains the new tool in visual studio 2010 which most of the users require seeing the comparison report of the 2 different database schema (say a development and a production db) in order to get the object that has been changed for the current releases.
  • Create a Strongly Typed DataSet Using The XML Schema Definition Tool (XSD.exe)Jun 27, 2011. In this article we are going to see how to create a strongly typed DataSet from a XSD schema file using the XML Schema Definition Tool (XSD.exe).
  • XML SchemaValidatorDec 01, 2011. This article shows how to validate an XML document against a schema using C#. For demonstration of this, I have created a GUI application using Visual Studio 2005 Express Edition.
  • Creating a Model Class to "LINQ to SQL" using ASP.NET MVC Dec 06, 2011. This is a simple application that show how to create model class to Link to Sql in MVC ASP.NET. In this application we first create the database after that create the schema and insert the data.
  • Entity Framework: Part 1Jan 18, 2012. The Entity Framework facilitates the development and conceptual use of application models for development instead of directly using relational storage schema.
  • Merge the Content of DataSets in ASP.NETJun 17, 2012. This article shows the use of the Merge() method in C# to merge two or more DataSet objects that have largely similar schemas to exist in the same Data Container.
  • Architecture of Search Schema in SharePoint 2013Oct 23, 2012. In this article we can see some very good information about the Search Schema of SharePoint 2013. The search index is one of the most important elements in search architecture. What is in our search index determines what people will find when they look for information by entering search queries or by interacting with internet or intranet pages.
  • Secure WS in VB.NETNov 09, 2012. This code covers the .NET (VB) implementation of the security of webservices using the Microsoft “The Favorites Service” security modified schema.
  • XML TreeView in VB.NETNov 10, 2012. The application shown here was my first adventure into Xml in the .Net platform. My goal was to be able to reflect any Xml file into the Windows Forms TreeView control. I found various examples online, but none I found were suited for opening all Xml files, rather they were suited to one schema or another.
  • XML Schema Validator in VB.NETNov 10, 2012. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model. If it finds the document is not a valid XML schema, it generates the error telling the problem in the schema.
  • Generating XML from SQL Database in VB.NETNov 10, 2012. This sample shows how you can obtain a Dataset from (in this case) a SQL Server database, and then write it out to an XML Document. As an "Extra Added Bonus(tm)", it can show you how to write the schema as well.
  • Secure WS in VB.NETNov 10, 2012. This code covers the .NET (VB) implementation of the security of web services using the Microsoft “The Favorites Service” security modified schema.
  • Schema in SQL Server 2012Dec 03, 2012. In this article I describe schemas in SQL Server 2012.
  • Visual Studio 2012 SQL Schema ComparisonJan 30, 2013. Visual Studio 2012 is very much a developer friendly and robust IDE. This article covers the enhanced schema comparison tool in terms of friendliness using self explanatory pictures/images.
  • The Database Principal Owns a Schema in the Database, and Cannot be DroppedMay 06, 2013. I encountered a problem today and thought to share with all of you so that in the future, if you confront such an issue then this article may help you.
  • Schema Compare Using Visual StudioMay 25, 2013. Consider a situation where we need to compare multiple databases and update one of those with latest changes. This can be easily achieved by using Schema Comparison Utility available in VS 2013/2012/2010/2008/2005, almost all versions.
  • Validating an XML Document ProgrammaticallyAug 18, 2013. This article provides an example of validating a XML document using the XmlReader and XMLScema class of System.Xml and System.Xml.Schema.
  • Let’s Understand the Levels of Document Object Model (DOM)Sep 27, 2013. This article describes the levels of the Document Object Model (DOM).
  • Copy Table Schema and Data From One Database to Another Database in SQL ServerOct 03, 2013. This article is all about how to copy table and its data in SQL Server using Query as well as graphically.
  • Oracle SQL Commands : Part 3 Oct 29, 2013. In Oracle we can create our own procedure. A procedure is a collection of SQL statement that can be called by any valid object name and create a user-defined procedure we use the command create Procedure.
  • Modifying InfoPath Form Based on XSD Schema Using Resource FilesDec 16, 2013. I came across a scenario where an InfoPath form was created based on an XSD schema. This schema changed frequently and the corresponding changes had to be made to the UI (InfoPath form template) accordingly.
  • Query to Find All About Database SchemaJan 26, 2014. In this short tip you will learn how to find information about a database schema in SQL Server.
  • Using Entity Framework to Work With DatabaseFeb 11, 2014. This article describes the database creation with the Entity Framework. You can also learn to apply the Data Annotation attributes in the database schema creation.
  • Memory-Optimized Tables in SQL Server 2014Mar 03, 2014. In this article you will learn about memory-optimized tables in SQL Server 2014.
  • Authentication Using WCF Message Security - 1Jul 28, 2014. In this article we will see how authentication can be done using Windows Authentication over message security, custom username and password authentication over the message security and finally the Mutual X509 authentication over the message security.
  • Entity Framework: Code First Data AnnotationsAug 13, 2014. Entity Framework code First approach allows us to use our POCO (domain) classes as model and Entity framework is use this classes to querying data, change tracking and other updating function.
  • Xml and Schema ValidatorAug 22, 2014. This article shows how to create a simple and generic module for validating XML files with their respective schema files.
  • Create Content Type Using SchemaNov 17, 2014. In this article we can explore how to create a content type using XML Schema.
  • Schemas in SQL ServerFeb 03, 2015. This article explains schemas in SQL Server.
  • Retrieve Checked Out Documents From Site Collection Using Content Search Web PartMar 27, 2015. This article helps in retrieving the Checked Out documents of the current user from the entire Site collection using a Content Search web part in SharePoint 2013.
  • Manage SQL Azure SecurityMay 03, 2015. In this article you wil learn how to manage SQL Azure Security: Logins, Users, Roles, Schemas and Permissions.
  • SharePoint: Create List With Lookup, Choice, Date And Person Fields (Schema)Oct 13, 2015. In this article you will learn how to create a list with Lookup, Choice, Date and Person Fields in SharePoint.
  • About Schema In SQL ServerNov 24, 2015. This article will help you to know about Schema and view the Schema changes history in SQL Server.
  • How To Generate A Script In SQL Server 2012Dec 19, 2015. In this article I will show you how to generate a script with schema and data and create a new database in SQL 2012.
  • Manage Search Schema Of Search Administration At The SharePoint Admin Center On Office 365Apr 25, 2016. In this article you will learn how to manage Search Schema of Search Administration at the SharePoint Admin Center on Office 365.

About schema

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!
VSLive! Anaheim