Show / Hide Table of Contents

    IDwMeta.CreateFromSql(ISqlQueryBuilder sqlBuilder, DataContext context) Method

    .NET Standard 2.x

    Creates an IDwMeta object using the SQL statement built by the ISqlQueryBuilder object.

    Namespace: DWNet.Data

    Assembly: DWNet.Data.dll

    Syntax

    public static IDwMeta CreateFromSql(ISqlQueryBuilder sqlBuilder, DataContext context);
    

    Parameters

    sqlBuilder SnapObjects.Data.ISqlQueryBuilder

    An ISqlQueryBuilder object used to build a SQL SELECT statement.

    context SnapObjects.Data.DataContext

    A DataContext object which represents the entry to the database.

    Returns

    DWNet.Data.IDwMeta

    The new IDwMeta object created based on the specified SQL builder object and DataContext.

    Examples

    The following code example demonstrates how to use the CreateFromSql method to create a DwMeta object from a SQL Query Builder.

    using DWNet.Data;
    using SnapObjects.Data;
    using System;
    
    namespace Appeon.ApiDoc.IDwMetaExamples
    {
        public class CreateFromSqlExample
        {
            private readonly SchoolContext _context;
    
            public CreateFromSqlExample(SchoolContext dataContext)
            {
                // Sets the data context
                _context = dataContext;
            }
    
            public void Example2()
            {
                // Defines a SQL Query Builder.
                var queryBuilder = new SqlQueryBuilder();
                queryBuilder.Select("DepartmentId")
                            .Select("Name")
                            .Select("Budget")
                            .From("Department", null, "dbo");
    
                // Creates a DwMeta object
                IDwMeta dwMeta = DwMeta.CreateFromSql(queryBuilder, _context);
    
                // Creates a DataStore from DwMeta.
                IDataStore ds = DataStore.Create(dwMeta, _context);
    
                // Gets the properties of the Columns.
                var columnMetas = ds.DwMeta.Columns;
                Console.WriteLine("Columns Count: {0}", columnMetas.Count);
    
                // Gets the zero-based ID of the column.  
                for (int i = 0; i < columnMetas.Count; i++)
                {
                    Console.WriteLine("Column Name: {0}; ID: {1}",
                        columnMetas[i].Name, columnMetas[i].ID);
                }
    
                /*This code produces the following output:
                
                Columns Count: 3
                Column Name: DepartmentId; ID: 0
                Column Name: Name; ID: 1
                Column Name: Budget; ID: 2
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon