ArcGIS Pro 3.3 API Reference Guide
ArcGIS.Core.Data Namespace / AttributedRelationship Class / FindField Method
The name of the field to be found.
Example

In This Topic
    FindField Method (AttributedRelationship)
    In This Topic
    Gets the index position for a field by name. This method must be called on the MCT. Use QueuedTask.Run.
    Syntax
    public int FindField( 
       string fieldName
    )
    Public Function FindField( _
       ByVal fieldName As String _
    ) As Integer

    Parameters

    fieldName
    The name of the field to be found.

    Return Value

    A positive integer value if the field is found indicating the index position of the field. If a field is not found with a name matching the fieldName, -1 is returned.
    Exceptions
    ExceptionDescription
    A geodatabase-related exception has occurred.
    This method or property must be called within the lambda passed to QueuedTask.Run
    Example
    RowOriginValue
    /*
    
       Copyright 2018 Esri
    
       Licensed under the Apache License, Version 2.0 (the "License");
       you may not use this file except in compliance with the License.
       You may obtain a copy of the License at
    
           http://www.apache.org/licenses/LICENSE-2.0
    
       Unless required by applicable law or agreed to in writing, software
       distributed under the License is distributed on an "AS IS" BASIS,
       WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    
       See the License for the specific language governing permissions and
       limitations under the License.
    
    */
    using System;
    using System.Threading.Tasks;
    using ArcGIS.Core.Data;
    using ArcGIS.Core.Geometry;
    using ArcGIS.Desktop.Core;
    using ArcGIS.Desktop.Editing;
    using ArcGIS.Desktop.Framework.Threading.Tasks;
    
    namespace SDKExamples.GeodatabaseSDK
    {
      /// <summary>
      /// Illustrates how to get the original value from a given field in a Row or Feature.
      /// </summary>
      /// 
      /// <remarks>
      /// <para>
      /// While it is true classes that are derived from the <see cref="ArcGIS.Core.CoreObjectsBase"/> super class 
      /// consumes native resources (e.g., <see cref="ArcGIS.Core.Data.Geodatabase"/> or <see cref="ArcGIS.Core.Data.FeatureClass"/>), 
      /// you can rest assured that the garbage collector will properly dispose of the unmanaged resources during 
      /// finalization.  However, there are certain workflows that require a <b>deterministic</b> finalization of the 
      /// <see cref="ArcGIS.Core.Data.Geodatabase"/>.  Consider the case of a file geodatabase that needs to be deleted 
      /// on the fly at a particular moment.  Because of the <b>indeterministic</b> nature of garbage collection, we can't
      /// count on the garbage collector to dispose of the Geodatabase object, thereby removing the <b>lock(s)</b> at the  
      /// moment we want. To ensure a deterministic finalization of important native resources such as a 
      /// <see cref="ArcGIS.Core.Data.Geodatabase"/> or <see cref="ArcGIS.Core.Data.FeatureClass"/>, you should declare 
      /// and instantiate said objects in a <b>using</b> statement.  Alternatively, you can achieve the same result by 
      /// putting the object inside a try block and then calling Dispose() in a finally block.
      /// </para>
      /// <para>
      /// In general, you should always call Dispose() on the following types of objects: 
      /// </para>
      /// <para>
      /// - Those that are derived from <see cref="ArcGIS.Core.Data.Datastore"/> (e.g., <see cref="ArcGIS.Core.Data.Geodatabase"/>).
      /// </para>
      /// <para>
      /// - Those that are derived from <see cref="ArcGIS.Core.Data.Dataset"/> (e.g., <see cref="ArcGIS.Core.Data.Table"/>).
      /// </para>
      /// <para>
      /// - <see cref="ArcGIS.Core.Data.RowCursor"/> and <see cref="ArcGIS.Core.Data.RowBuffer"/>.
      /// </para>
      /// <para>
      /// - <see cref="ArcGIS.Core.Data.Row"/> and <see cref="ArcGIS.Core.Data.Feature"/>.
      /// </para>
      /// <para>
      /// - <see cref="ArcGIS.Core.Data.Selection"/>.
      /// </para>
      /// <para>
      /// - <see cref="ArcGIS.Core.Data.VersionManager"/> and <see cref="ArcGIS.Core.Data.Version"/>.
      /// </para>
      /// </remarks>
      public class RowOriginalValue
      {
        /// <summary>
        /// In order to illustrate that Geodatabase calls have to be made on the MCT
        /// </summary>
        /// <returns></returns>
        public async Task MainMethodCode()
        {
          await QueuedTask.Run(async () =>
          {
            await EnterpriseGeodabaseWorkFlow();
            await FileGeodatabaseWorkFlow();
          });
        }
    
        private static async Task EnterpriseGeodabaseWorkFlow()
        {
          // Opening a Non-Versioned SQL Server instance.
    
          DatabaseConnectionProperties connectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.SQLServer)
          {
            AuthenticationMode = AuthenticationMode.DBMS,
    
            // Where testMachine is the machine where the instance is running and testInstance is the name of the SqlServer instance.
            Instance = @"testMachine\testInstance",
    
            // Provided that a database called LocalGovernment has been created on the testInstance and geodatabase has been enabled on the database.
            Database = "LocalGovernment",
    
            // Provided that a login called gdb has been created and corresponding schema has been created with the required permissions.
            User = "gdb",
            Password = "password",
            Version = "dbo.DEFAULT"
          };
    
          using (Geodatabase geodatabase = new Geodatabase((connectionProperties)))
          using (Table enterpriseTable = geodatabase.OpenDataset<Table>("LocalGovernment.GDB.piCIPCost"))
          {
            EditOperation editOperation = new EditOperation();
            editOperation.Callback(context =>
            {
              QueryFilter openCutFilter = new QueryFilter { WhereClause = "ACTION = 'Open Cut'" };
    
              using (RowCursor rowCursor = enterpriseTable.Search(openCutFilter, false))
              {
                TableDefinition tableDefinition = enterpriseTable.GetDefinition();
    
                int assetNameIndex = tableDefinition.FindField("ASSETNA");
    
                while (rowCursor.MoveNext())
                {
                  using (Row row = rowCursor.Current)
                  {
                    // Will be same as row[assetNameIndex].
                    string originalValueBeforeChange = row.GetOriginalValue(assetNameIndex) as String;
    
                    // In order to update the Map and/or the attribute table.
                    // Has to be called before any changes are made to the row
                    context.Invalidate(row);
    
                    row[assetNameIndex] = "wMainOpenCut";
    
                    //Will be same as row[assetNameIndex].
                    string originalValueAfterChange = row.GetOriginalValue(assetNameIndex) as String;
    
                    // After all the changes are done, persist it.
                    row.Store();
    
                    // Has to be called after the store too
                    context.Invalidate(row);
    
                    // Will be "wMainOpenCut".
                    string originalValueAfterStore = row.GetOriginalValue(assetNameIndex) as String;
                  }
                }
              }
            }, enterpriseTable);
    
            bool editResult = editOperation.Execute();
    
            // If the table is non-versioned this is a no-op. If it is versioned, we need the Save to be done for the edits to be persisted.
    
            bool saveResult = await Project.Current.SaveEditsAsync();
          }
        }
    
        //Illustrating creating a row in a File GDB
        private static async Task FileGeodatabaseWorkFlow()
        {
          using (Geodatabase fileGeodatabase = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(@"C:\Data\LocalGovernment.gdb"))))
          using (FeatureClass featureClass = fileGeodatabase.OpenDataset<FeatureClass>("PollingPlace"))
          {
            EditOperation editOperation = new EditOperation();
            editOperation.Callback(context =>
            {
              QueryFilter queryFilter = new QueryFilter { WhereClause = "FULLADD LIKE '%Lily Cache Ln%'" };
    
              using (RowCursor rowCursor = featureClass.Search(queryFilter, false))
              {
                FeatureClassDefinition featureClassDefinition = featureClass.GetDefinition();
    
                int shapeFieldIndex = featureClassDefinition.FindField(featureClassDefinition.GetShapeField());
    
                while (rowCursor.MoveNext())
                {
                  using (Feature feature = (Feature)rowCursor.Current)
                  {
                    MapPoint mapPoint = feature.GetShape() as MapPoint;
    
                    // Will be the same as feature.GetShape().
                    Geometry originalValueBeforeChange = feature.GetOriginalValue(shapeFieldIndex) as Geometry;
    
                    // In order to update the Map and/or the attribute table.
                    // Has to be called before any changes are made to the row
                    context.Invalidate(feature);
    
                    MapPoint newShape = new MapPointBuilderEx(mapPoint.X + 10, mapPoint.Y, mapPoint.SpatialReference).ToGeometry();
                    feature.SetShape(newShape);
    
                    // Will be the same as feature.GetShape().
                    Geometry originalValueAfterChange = feature.GetOriginalValue(shapeFieldIndex) as Geometry;
    
                    feature.Store();
                    // Will be the same as newShape.
                    Geometry originalValueAfterStore = feature.GetOriginalValue(shapeFieldIndex) as Geometry;
    
                    // Has to be called after the store too
                    context.Invalidate(feature);
                  }
                }
              }
            }, featureClass);
    
            bool editResult = editOperation.Execute();
    
            //This is required to persist the changes to the disk.
    
            bool saveResult = await Project.Current.SaveEditsAsync();
          }
        }
      }
    }
    Requirements

    Target Platforms: Windows 11, Windows 10

    ArcGIS Pro version: 3 or higher.
    See Also