Syniti Data Replication (旧DBMoto)でのスクリプトの書き方⑤：フィールドマッピング関数の書き方

Public Class MappingRule : Inherits IMappingRule
	<MappingRuleAttribute("Match By Target Prefix", "ターゲットの接頭辞'fld_'を考慮して名前を一致")>
	Public Function CustomMapping_ByNameTPrefixed (
			ByVal sSourceName As String,
			ByVal iSourceOrdinal As Integer,
			ByVal sTargetName As String,
			ByVal iTargetOrdinal As Integer) As Boolean
           If sTargetName.Length >= 4 Then
		Return (String.Compare(sSourceName, sTargetName.SubString(4), True) = 0)
	    Else
		Return False
	    End If
	End Function
      
	<MappingRuleAttribute("Match By Source Preffix", "ソースの接頭辞'fld_'を考慮して名前を一致")>
	Public Function CustomMapping_ByNameSPrefixed (
			ByVal sSourceName As String,
			ByVal iSourceOrdinal As Integer,
			ByVal sTargetName As String,
			ByVal iTargetOrdinal As Integer) As Boolean
	   If sSourceName.Length >= 4
		Return (String.Compare(sSourceName.SubString(4), sTargetName, True) = 0)
	   Else
		Return False
	   End If
	End Function    
 
	<MappingRuleAttribute("Match Custom", "特定のカスタムルールを考慮して名前を一致")>
	Public Function MyCustomMapping (
			ByVal bIsForth As Boolean,
			ByVal sSourceName As String,
			ByVal iSourceOrdinal As Integer,
			ByVal sSourceType As String,
			ByVal sTargetName As String,
			ByVal iTargetOrdinal As Integer,
			ByVal sTargetType As String,
			ByRef sExpression As System.Text.StringBuilder) As Boolean
			///     ...
	End Function
	<MappingRuleAttribute("Match Custom Extended Params", "特定のカスタムルールを考慮して名前を一致")>
	Public Function MyCustomMapping (
			ByVal bIsForth As Boolean,
			ByVal sSourceName As String,
			ByVal iSourceOrdinal As Integer,
			ByVal sSourceType As String,
			ByVal bIsSourcePrimaryKey As Boolean,
			ByVal bIsSourceNullable As Boolean,   
			ByVal iSourceSize As Integer,
			ByVal sSourcePrecision As Short,
			ByVal sSourceScale As Short,
			ByVal sTargetName As String,
			ByVal iTargetOrdinal As Integer,
			ByVal sTargetType As String,
			ByVal bIsTargetPrimaryKey As Boolean,
			ByVal bIsTargetNullable As Boolean,
			ByVal iTargetSize As Integer,
			ByVal sTargetPrecision As Short,
			ByVal sTargetScale As Short,
			ByRef sExpression As System.Text.StringBuilder) As Boolean
			///     ...
	End Function
End Class		

using System;
using System.Data;
using DBMotoPublic;
using DBMotoScript;
namespace DBRS
{
   public class GlobalScript : IGlobalScript
   {
   }
   public class MappingRule : IMappingRule
   {
     [MappingRuleAttribute("Match By Target Prefix", "ターゲットの接頭辞'fld_'を考慮して名前を一致")]
     public bool CustomMapping_ByNameTPrefixed (String sSourceName, int iSourceOrdinal, String sTargetName, int iTargetOrdinal)
	{
	   if (sTargetName.Length >= 4)
	      {
		return (String.Compare(sSourceName, sTargetName.Substring(4), true) == 0);
	       }
	   else
	       {
		return false;
	        }
	}
    
	[MappingRuleAttribute("Match By Source Prefix", "ソースの接頭辞'fld_'を考慮して名前を一致")]
	public bool CustomMapping_ByNameSuffixed (String sSourceName, int iSourceOrdinal, String sTargetName, int iTargetOrdinal)
	{
	   if (sSourceName.Length >= 4)
		{
		   return (String.Compare(sSourceName.Substring(4), sTargetName, true) == 0);
		}
	   else
		{
		   return false;
		}
	  }
	[MappingRuleAttribute("Match Custom", "特定のカスタムルールを考慮して名前を一致")]
	public bool MyCustomMapping(bool bIsForth, String sSourceName, int iSourceOrdinal, String sSourceType, 
          String sTargetName, int iTargetOrdinal, String sTargetType, ref System.Text.StringBuilder sExpression)
	{
	  //      ...
	  return true;
	}
   }
   public class GlobalEvents : IGlobalEvents
   {
   }
}