C# Corner

Related resources for Schema
  • Data Warehouse Star Schema In SQL10/11/2019 7:13:08 AM. In this article, you will learn about Data Warehouse Star Schema in SQL.
  • Authentication Using WCF Message Security - 19/26/2019 3:32:40 AM. 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 Mu
  • Copy Table Schema and Data From One Database to Another Database in SQL Server8/18/2019 5:35:43 PM. This article is all about how to copy SQL Server tables and their data from one database to another database.
  • CommandBuilder in C#7/23/2019 8:51:31 PM. Learn how to use ADO.NET CommandBuilder in C#.
  • Schema in SQL Server 20127/10/2019 4:31:05 AM. In this article, I describe schemas in SQL Server 2012. A SQL schema is like a container that contains database objects like tables, views etc. So let us learn about schemas, creation of schemas, how
  • Schema In SQL Server6/8/2019 8:44:03 AM. This article explains schemas in SQL Server. A SQL schema in a database is a collection of logical structures of data.
  • Changing User Information using Active Directory3/6/2019 5:12:59 AM. 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
  • Making Custom Function Deterministic With SCHEMABINDING And Its Impact On DB Objects8/13/2018 11:44:43 PM. In this video, we will learn to make custom functions or User-Defined Functions in SQL Server Deterministic by using the "SCHEMABINDING" keyword.
  • Zero To Hero In MS SQL Server - Part Three8/3/2018 1:59:40 PM. In this article, I have shared knowledge in Schema and Tables in MS SQL Server.
  • Zero To Hero In MS SQL Server - Part Two7/30/2018 2:41:23 PM. In this article, I have shared knowledge about Database and schema and table creation in SQL. This is a continuation of Part One
  • Entity Framework, Its Approaches, And How It Maps The Conceptual Schema With Storage Schema5/14/2018 11:21:15 AM. It is a tool to access the database. More accurately, it’s classified as an Object/Relational Mapper (ORM) which means it maps data in a relational database into objects of our applications.
  • Provisioning SharePoint List With Custom Schema Using SPFx Solution4/6/2017 2:01:27 PM. In this article, let us look at provisioning SharePoint lists using schema file with SharePoint Framework components.
  • Manage Search Schema Of Search Administration At The SharePoint Admin Center On Office 3654/25/2016 12:27:29 PM. In this article you will learn how to manage Search Schema of Search Administration at the SharePoint Admin Center on Office 365.
  • About Schema In SQL Server11/24/2015 2:17:17 AM. This article will help you to know about Schema and view the Schema changes history in SQL Server.
  • SharePoint: Create List With Lookup, Choice, Date And Person Fields (Schema)10/13/2015 10:50:10 AM. In this article you will learn how to create a list with Lookup, Choice, Date and Person Fields in SharePoint.
  • SchemaBinding In SQL Server9/6/2015 3:58:57 AM. This article describes what is SchemaBinding and its advantages in SQL SERVER.
  • Schema Compare Using Visual Studio6/1/2015 3:32:09 PM. 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.
  • Retrieve Checked Out Documents From Site Collection Using Content Search Web Part3/27/2015 7:30:48 PM. 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.
  • Create Content Type Using Schema11/17/2014 5:54:44 PM. In this article we can explore how to create a content type using XML Schema.
  • Xml and Schema Validator8/22/2014 1:20:04 PM. This article shows how to create a simple and generic module for validating XML files with their respective schema files.
  • Entity Framework: Code First Data Annotations8/13/2014 6:40:51 PM. 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.
  • Memory-Optimized Tables in SQL Server 20143/3/2014 5:40:46 PM. In this article you will learn about memory-optimized tables in SQL Server 2014.
  • Query to Find All About Database Schema1/27/2014 12:33:22 AM. In this short tip you will learn how to find information about a database schema in SQL Server.
  • Modifying InfoPath Form Based on XSD Schema Using Resource Files12/16/2013 8:06:54 PM. 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.
  • Oracle SQL Commands : Part 3 10/31/2013 6:22:46 AM. 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.
  • Let’s Understand the Levels of Document Object Model (DOM)9/27/2013 2:56:20 PM. This article describes the levels of the Document Object Model (DOM).
  • View database structure using C#7/31/2013 9:05:34 AM. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • The Database Principal Owns a Schema in the Database, and Cannot be Dropped5/6/2013 2:23:38 PM. 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.
  • Visual Studio 2012 SQL Schema Comparison2/2/2013 2:55:43 AM. 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.
  • XML Schema Validator in VB.NET11/10/2012 1:31:57 AM. 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.
  • Architecture of Search Schema in SharePoint 201310/25/2012 12:29:06 AM. 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.
  • Create a Strongly Typed DataSet Using The XML Schema Definition Tool (XSD.exe)10/22/2012 9:11:09 AM. 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).
  • DataSets in Microsoft .NET10/20/2012 3:26:48 AM. 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.
  • CopySchema - Part 210/20/2012 2:14:06 AM. 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.
  • Retrieving Schema Information Using ADO.NET and C#10/20/2012 2:09:38 AM. 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.
  • Best Approach for Designing Interoperable Web Service10/13/2012 5:52:26 AM. 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.
  • Create a SQL Server CE Database From SQL Schema File10/5/2012 8:04:02 AM. In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
  • In-depth Look at WMI and Instrumentation: Part I9/30/2012 4:16:45 AM. 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.
  • Best Practices for Data Transfer in SQL Server 20059/29/2012 9:40:42 AM. This article talks about some best practices and the process of data transfer in SQL Server 2005.
  • Generating XML from SQL database9/29/2012 7:39:56 AM. Some Days Back i posted the article dealing XML as a Middle tier but i guess the People didn't get the clear funda.
  • Validating Input Xml Data Files9/29/2012 7:21:32 AM. 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.
  • XML Schema Validator9/29/2012 6:29:52 AM. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model.
  • Using XML and XSLT5/20/2012 7:22:42 AM. 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.
  • XML Namespaces5/20/2012 6:29:23 AM. In this article I will explain you about XML namespace, DTD and schemas and Extensible Hyper Text Markup Language.
  • Visual Studio .NET and XML Support5/20/2012 6:24:48 AM. In this article I will explain you about Visual Studio .NET and XML support.
  • ADO .NET and XML5/20/2012 6:24:12 AM. In this article I will explain you about ADO .NET and XML.
  • Biztalk Messaging Services: Flat File Schema5/15/2012 8:35:45 PM. This article is intended to consolidate the principles of messaging in Biztalk Server 2006.
  • Receiving Messages With Multiple Schemas in a Single Orchestration5/15/2012 2:10:25 PM. 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.
  • Promoting Schemas Properties in BizTalk Server5/15/2012 1:57:26 PM. 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.
  • Compare the Schemas of two Databases5/13/2012 8:23:33 AM. In this simple project without even writing a single line of code, now I'll show you how easy it is, compare the schemas of two databases and make them identical with a few steps.
  • Parsing BizTalk Messages in .NET Components Through Orchestration5/13/2012 4:03:23 AM. This article discusses how to parse BizTalk messages in .NET Components through Orchestration.
  • Using the Data Form Wizard in ADO.NET3/2/2012 4:59:53 AM. In this article I will explain about using the Data Form Wizard in ADO.NET.
  • Get The Content Type SchemaXml For The Specified Content Type in SharePoint 2010 Using ECMAScript1/24/2012 3:36:12 PM. In this article you will see how to get the content type schemaXml for the specified content type in SharePoint 2010 using ECMAScript.
  • Entity Framework: Part 11/22/2012 3:10:07 AM. The Entity Framework facilitates the development and conceptual use of application models for development instead of directly using relational storage schema.
  • XML SchemaValidator12/2/2011 12:51:15 AM. 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.
  • SQL Server Schema Comparison in Visual Studio 20103/6/2011 10:53:30 PM. 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.
  • Schemas in SQL Server10/18/2010 1:40:39 AM. 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.
  • Model-First Design using ADO.NET Entity Framework 4.0 7/19/2010 3:04:32 AM. In this article we are going to see the second most importment part of the ADO.NET entity framework 4.0.
  • Getting a Database Schema 3/11/2010 4:17:35 AM. In this article I will explain getting a Database Schema.
  • Creating a Guest Book in ASP.NET 1/29/2010 12:44:36 AM. In this article I will explain Creating a Guest Book in ASP.NET.
  • Adding Typed DataSets in ADO.NET 12/15/2009 6:07:36 AM. In this article I will explain about Adding Typed DataSets in ADO.NET.
  • Working with DataSets12/4/2009 5:36:28 AM. In this article I will explain about working with DataSets.
  • Biztalk Messaging Services4/3/2008 7:22:09 AM. This article is intended to illustrate the concepts of mapping in Biztalk Server 2006.
  • TranslateSQL1/29/2007 3:32:51 AM. 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.
  • Using Snippets in Visual Studio 20059/1/2006 1:52:48 AM. 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.
  • Working With OleDb Data Adapters 8/29/2006 8:36:59 AM. This step by step tutorial guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • SOAP Client in Windows XP2/28/2006 12:08:38 AM. This article covers the basics of using the SOAP Client software included with Microsoft Windows XP Professional to access Web Services using SOAP.
  • Leveraging on XML feature of Microsoft Office Word 20031/7/2006 5:42:57 AM. 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.
  • Creating Graphics with XML12/26/2005 5:46:26 AM. This article shows how to create images on the fly and uses XML to specify the properties of the images.
  • CopySchema12/13/2005 6:12:39 PM. 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.