Show / Hide Table of Contents

    ISqlModelMapper.TrackUpdate<TModel>(TModel model) Method

    .NET Standard 2.x

    Tracks a database table update operation. The data that will be updated to the database table is cached in the TModel object. When ISqlModelMapper.SaveChanges method is called, a SQL UPDATE statement will be first generated using the data cached in the TModel object and the mapping information defined in TModel class, and then executed.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      public ISqlModelMapper TrackUpdate<TModel>(TModel model);
    

    Type Parameters

    TModel

    The type of a model class.

    Parameters

    model TModel

    The TModel object that contains the data you want to update to database.

    Returns

    SnapObjects.Data.ISqlModelMapper

    Returns the current ISqlModelMapper object, which can be used for executing other methods.

    Examples

    The following code example demonstrates how to use TrackUpdate<TModel>(TModel) method to track a database table update operation.

    using Appeon.ApiDoc.Models.School;
    using System;
    
    namespace Appeon.ApiDoc.ISqlModelMapperExamples
    {
        public class TrackUpdateExample
        {
            private SchoolContext _context;
    
            public TrackUpdateExample(SchoolContext dataContext)
            {
                // Sets the data context.
                _context = dataContext;
            }
    
            public void Example1()
            {
                var mapper = _context.SqlModelMapper;
    
                // Gets the Engineering Department record (DepartmentID = 1) from 
                // the database.
                var department = mapper.LoadByKey<Department>(1).FirstOrDefault();
    
                mapper.TrackUpdate(department);
    
                Console.WriteLine("The department name is {0} (DepartmentID = 1).",
                   department.Name);
    
                department.Name = "New Name";
    
                mapper.SaveChanges();
    
                // Gets data from the database.
                // DepartmentID=1, Name=Engineering_test
                department = mapper.LoadByKey<Department>(1).FirstOrDefault();
                Console.WriteLine("The name is {0} (DepartmentID = 1).",
                    department.Name);
    
                /*The code example produces the following output:
                The name is Engineering (DepartmentID = 1).
                The name is New Name (DepartmentID = 1).
                */
            }
        }
    }
    

    Example Refer To

    Model Class: Department

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon