{"id":3751,"date":"2026-02-26T15:50:51","date_gmt":"2026-02-26T08:50:51","guid":{"rendered":"https:\/\/portal-atlasx.cdg.co.th\/home\/?post_type=docs&p=3751"},"modified":"2026-03-05T09:02:28","modified_gmt":"2026-03-05T02:02:28","slug":"dataaccessconnectorbase","status":"publish","type":"docs","link":"https:\/\/portal-atlasx.cdg.co.th\/home\/docs\/ax-engine\/dataaccess\/dataaccessconnectorbase\/","title":{"rendered":"DataAccessConnectorBase"},"content":{"rendered":"\n

DataAccessConnectorBase<\/h2>\n\n\n\n

AtlasX.Engine.DataAccess.Core.Base
Abstract base class \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a database connector \u0e17\u0e38\u0e01\u0e15\u0e31\u0e27\u0e43\u0e19 DataAccess library<\/p>\n\n\n\n

<\/p>\n\n\n\n

Namespace: AtlasX.Engine.DataAccess.Core.Base
Implements: IDataAccessConnector
Inherited <\/strong>by: OracleConnector, PostgreSqlConnector, SqlServerConnector, MongoDbConnector, RedisConnector<\/p>\n\n\n\n

Properties<\/strong><\/h3>\n\n\n\n
Name<\/td>Description<\/td><\/tr>
IsConnected<\/td>\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e27\u0e48\u0e32 connection \u0e40\u0e1b\u0e34\u0e14\u0e2d\u0e22\u0e39\u0e48\u0e2b\u0e23\u0e37\u0e2d\u0e44\u0e21\u0e48 (true = Open)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Methods<\/strong><\/h3>\n\n\n\n
Name<\/strong><\/td>Return<\/strong><\/td>Description<\/strong><\/td><\/tr>
OpenAsync(CancellationToken)<\/code><\/td>void<\/code><\/td>\u0e40\u0e1b\u0e34\u0e14 connection \u0e44\u0e1b\u0e22\u0e31\u0e07 database<\/td><\/tr>
CloseAsync(CancellationToken)<\/code><\/td>void<\/code><\/td>\u0e1b\u0e34\u0e14 connection \u0e41\u0e25\u0e30 dispose resources<\/td><\/tr>
ExecuteStatementAsync(String, Dictionary, DbExecutionOptions, CancellationToken)<\/code><\/td>int<\/code><\/td>Execute SQL statement \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e08\u0e33\u0e19\u0e27\u0e19 rows \u0e17\u0e35\u0e48\u0e44\u0e14\u0e49\u0e23\u0e31\u0e1a\u0e1c\u0e25\u0e01\u0e23\u0e30\u0e17\u0e1a<\/td><\/tr>
ExecuteScalarStatementAsync<TResult>(String, Dictionary, DbExecutionOptions, CancellationToken)<\/code><\/td>TResult?<\/code><\/td>Execute SQL statement \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e04\u0e48\u0e32 scalar value<\/td><\/tr>
QueryStatementAsync<TResult>(String, Dictionary, DbExecutionOptions, CancellationToken)<\/code><\/td>TResult<\/code><\/td>Execute SQL SELECT \u0e41\u0e25\u0e30 map \u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e40\u0e1b\u0e47\u0e19 TResult<\/td><\/tr>
ExecuteProcedureAsync(String, Dictionary, DbExecutionOptions, CancellationToken)<\/code><\/td>QueryResult<\/code><\/td>Execute Stored Procedure \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19 QueryResult<\/td><\/tr>
DisposeAsync()<\/code><\/td>void<\/code><\/td>\u0e1b\u0e34\u0e14 connection \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19 resources \u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Methods<\/strong> Details<\/strong><\/h3>\n\n\n\n
\n

OpenAsync(CancellationToken)<\/strong><\/h4>\n\n\n\n

\u0e40\u0e1b\u0e34\u0e14 connection \u0e44\u0e1b\u0e22\u0e31\u0e07 database \u0e16\u0e49\u0e32\u0e22\u0e31\u0e07\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e40\u0e1b\u0e34\u0e14
\u0e41\u0e15\u0e48\u0e2b\u0e32\u0e01 IsConnected \u0e40\u0e1b\u0e47\u0e19 true \u0e2d\u0e22\u0e39\u0e48\u0e41\u0e25\u0e49\u0e27\u0e08\u0e30 skip \u0e42\u0e14\u0e22\u0e44\u0e21\u0e48\u0e40\u0e1b\u0e34\u0e14\u0e0b\u0e49\u0e33
<\/p>\n\n\n\n

Parameter<\/strong><\/td>Type<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
cancellationToken<\/code><\/td>CancellationToken<\/code><\/td>Optional<\/td>Token \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e01\u0e40\u0e25\u0e34\u0e01 operation<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\n
\n

CloseAsync(CancellationToken)<\/strong><\/h4>\n\n\n\n

\u0e1b\u0e34\u0e14 connection \u0e41\u0e25\u0e30 dispose resources
\u0e41\u0e15\u0e48\u0e2b\u0e32\u0e01connection \u0e40\u0e1b\u0e47\u0e19 null<\/code> \u0e2b\u0e23\u0e37\u0e2d\u0e1b\u0e34\u0e14\u0e2d\u0e22\u0e39\u0e48\u0e41\u0e25\u0e49\u0e27\u0e08\u0e30 skip \u0e42\u0e14\u0e22\u0e44\u0e21\u0e48\u0e17\u0e33\u0e2d\u0e30\u0e44\u0e23
<\/p>\n\n\n\n

Parameter<\/strong><\/td>Type<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
cancellationToken<\/code><\/td>CancellationToken<\/code><\/td>Optional<\/td>Token \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e01\u0e40\u0e25\u0e34\u0e01 operation<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\n
\n

ExecuteStatementAsync(String, Dictionary, DbExecutionOptions, CancellationToken)<\/strong><\/h4>\n\n\n\n

Execute SQL statement (INSERT \/ UPDATE \/ DELETE) \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19\u0e08\u0e33\u0e19\u0e27\u0e19\u0e23\u0e32\u0e22\u0e01\u0e32\u0e23 (rows) \u0e17\u0e35\u0e48\u0e44\u0e14\u0e49\u0e23\u0e31\u0e1a\u0e1c\u0e25\u0e01\u0e23\u0e30\u0e17\u0e1a
<\/p>\n\n\n\n

Parameter<\/strong><\/td>Type<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
sql<\/code><\/td>string<\/code><\/td>Required<\/td>SQL statement<\/td><\/tr>
parameters<\/code><\/td>Dictionary<string, object>?<\/code><\/td>Optional<\/td>Parameters \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a SQL<\/td><\/tr>
options<\/code><\/td>DbExecutionOptions?<\/code><\/td>Optional<\/td>Execution options \u0e40\u0e0a\u0e48\u0e19 timeout<\/td><\/tr>
cancellationToken<\/code><\/td>CancellationToken<\/code><\/td>Optional<\/td>Token \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e01\u0e40\u0e25\u0e34\u0e01 operation<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\n
\n

QueryStatementAsync<TResult>(String, Dictionary<String, Object>, DbExecutionOptions, CancellationToken)<\/strong><\/h4>\n\n\n\n

Execute SQL SELECT statement \u0e41\u0e25\u0e30 map \u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c\u0e40\u0e1b\u0e47\u0e19 TResult
<\/p>\n\n\n\n

Parameter<\/strong><\/td>Type<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
sql<\/code><\/td>string<\/code><\/td>Required<\/td>SQL SELECT statement<\/td><\/tr>
parameters<\/code><\/td>Dictionary<string, object>?<\/code><\/td>Optional<\/td>Parameters \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a SQL<\/td><\/tr>
options<\/code><\/td>DbExecutionOptions?<\/code><\/td>Optional<\/td>Execution options \u0e40\u0e0a\u0e48\u0e19 timeout<\/td><\/tr>
cancellationToken<\/code><\/td>CancellationToken<\/code><\/td>Optional<\/td>Token \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e01\u0e40\u0e25\u0e34\u0e01 operation<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\n
\n

ExecuteProcedureAsync(String, Dictionary<String, Object>, DbExecutionOptions, CancellationToken)<\/strong><\/h4>\n\n\n\n

Execute Stored Procedure \u0e41\u0e25\u0e30 map output parameters \u0e01\u0e25\u0e31\u0e1a\u0e40\u0e1b\u0e47\u0e19 QueryResult
<\/p>\n\n\n\n

Parameter<\/strong><\/td>Type<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
procedureName<\/code><\/td>string<\/code><\/td>Required<\/td>\u0e0a\u0e37\u0e48\u0e2d Stored Procedure<\/td><\/tr>
parameters<\/code><\/td>Dictionary<string, object>?<\/code><\/td>Optional<\/td>Input parameters (\u0e43\u0e0a\u0e49\u0e0a\u0e37\u0e48\u0e2d\u0e42\u0e14\u0e22\u0e44\u0e21\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e21\u0e35 prefix PI_)<\/td><\/tr>
options<\/code><\/td>DbExecutionOptions?<\/code><\/td>Optional<\/td>Execution options \u0e40\u0e0a\u0e48\u0e19 timeout, trace<\/td><\/tr>
cancellationToken<\/code><\/td>CancellationToken<\/code><\/td>Optional<\/td>Token \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e22\u0e01\u0e40\u0e25\u0e34\u0e01 operation<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\n
\n

DisposeAsync()<\/strong><\/h4>\n\n\n\n

\u0e1b\u0e34\u0e14 connection \u0e41\u0e25\u0e30\u0e04\u0e37\u0e19 resources \u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14<\/p>\n<\/div>\n\n\n\n


<\/p>\n\n\n\n

<\/p>\n","protected":false},"featured_media":0,"parent":3750,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"nav_title":"","positive":"","negative":"","footnotes":""},"docs_category":[],"class_list":["post-3751","docs","type-docs","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs\/3751","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/comments?post=3751"}],"version-history":[{"count":36,"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs\/3751\/revisions"}],"predecessor-version":[{"id":3917,"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs\/3751\/revisions\/3917"}],"up":[{"embeddable":true,"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs\/3750"}],"wp:attachment":[{"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/media?parent=3751"}],"wp:term":[{"taxonomy":"docs_category","embeddable":true,"href":"https:\/\/portal-atlasx.cdg.co.th\/home\/wp-json\/wp\/v2\/docs_category?post=3751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}