daenetCorporation/Daenet.Common.Logging.Sql

Create Mapper

hvetter-de opened this issue · 0 comments

We need a mapping for mapping the following things:
Keys in Scope Dictionary TO Column
ColumnA TO ColumnB

We need this for compatibility reasons, for example the following table has to work, too.

CREATE TABLE [dbo].[TMon_Test](
       [Id] [bigint] IDENTITY(1,1) NOT NULL,
       [EventId] [int] NULL,
       [TracingLevel] [int] NULL,
       [Type] [nvarchar](3) NOT NULL,
       [Message] [nvarchar](max) NOT NULL,
       [Exception] [nvarchar](max) NULL,
       [TimeStamp] [datetime] NOT NULL,
       [Source] [nvarchar](255) NOT NULL,
       [Param0] [nvarchar](max) NULL,
       [Param1] [nvarchar](max) NULL,
       [Param2] [nvarchar](max) NULL,
       [Param3] [nvarchar](max) NULL,
       [Param4] [nvarchar](max) NULL,
       [Param5] [nvarchar](max) NULL,
       [Param6] [nvarchar](max) NULL,
       [Param7] [nvarchar](max) NULL,
       [Param8] [nvarchar](max) NULL,
       [Param9] [nvarchar](max) NULL,
       [Scope] [nvarchar](max) NULL,
 CONSTRAINT [PK_TMon_ETest] PRIMARY KEY CLUSTERED 
(
       [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO