//using System;
//using System.Collections.Generic;
//using System.Linq;
////using System.Linq.Dynamic.Core;
//using System.Text;
//using System.Threading.Tasks;
//using GB5Shared.DTO.Framework.Login;

//namespace FrameworkDAL.CustomCode.QueryExecutor
//{
//    public interface IQueryExecutor
//    {
//        /// <summary>
//        /// Fetches a single record as a DTO based on the SQL query.
//        /// </summary>
//        /// <typeparam name="T">The type of DTO.</typeparam>
//        /// <param name="sql">The SQL query string.</param>
//        /// <param name="parameters">Optional parameters for the SQL query.</param>
//        /// <returns>A single DTO or null if no match.</returns>
//        Task<T> QuerySingleAsync<T>(LoginDTO LoginDTO, string sql, object parameters = null);

//        ///// <summary>
//        ///// Fetches multiple records as a list of DTOs based on the SQL query.
//        ///// </summary>
//        ///// <typeparam name="T">The type of DTO.</typeparam>
//        ///// <param name="sql">The SQL query string.</param>
//        ///// <param name="parameters">Optional parameters for the SQL query.</param>
//        ///// <returns>A list of DTOs.</returns>
//         Task<IEnumerable<T>> QueryAsync<T>(LoginDTO LoginDTO, string sql, object parameters = null);



//        ///// <summary>
//        ///// Fetches multiple records as a list of DTOs based on the SQL query.
//        ///// </summary>
//        ///// <typeparam name="T">The type of DTO.</typeparam>
//        ///// <param name="sql">The SQL query string.</param>
//        ///// <param name="parameters">Optional parameters for the SQL query.</param>
//        ///// <returns>A list of DTOs.</returns>
//        Task<IEnumerable<T>> QueryAsync<T>(string ConnectionName, string sql, object parameters = null);

//        ///// <summary>
//        ///// Executes a SQL command (insert, update, delete, etc.) and returns the number of affected rows.
//        ///// </summary>
//        ///// <param name="sql">The SQL command string.</param>
//        ///// <param name="parameters">Optional parameters for the SQL command.</param>
//        ///// <returns>The number of affected rows.</returns>
//        Task<int> ExecuteAsync(LoginDTO LoginDTO, string sql, object parameters = null);

//        ///// <summary>
//        ///// Streams the results of a query asynchronously, suitable for large datasets.
//        ///// </summary>
//        ///// <typeparam name="T">The type of DTO.</typeparam>
//        ///// <param name="sql">The SQL query string.</param>
//        ///// <param name="parameters">Optional parameters for the SQL query.</param>
//        ///// <returns>An asynchronous stream of DTOs.</returns>
//         IAsyncEnumerable<T> StreamAsync<T>(LoginDTO LoginDTO, string sql, object parameters = null);

//        ///// <summary>
//        ///// Fetches records in a paginated fashion based on the SQL query.
//        ///// </summary>
//        ///// <typeparam name="T">The type of DTO.</typeparam>
//        ///// <param name="sql">The SQL query string with pagination logic (e.g., OFFSET and FETCH).</param>
//        ///// <param name="parameters">Optional parameters for the SQL query.</param>
//        ///// <returns>A list of DTOs and total count for pagination.</returns>
//        Task<PagedResult<T>> QueryPagedAsync<T>(LoginDTO LoginDTO, string sql, object parameters = null);

//        ///// <summary>
//        ///// Executes a bulk insert for a collection of DTOs.
//        ///// </summary>
//        ///// <typeparam name="T">The type of DTO to insert.</typeparam>
//        ///// <param name="sql">The SQL query for the insert operation.</param>
//        ///// <param name="items">The collection of DTOs to insert.</param>
//        ///// <returns>The number of rows affected.</returns>

//        Task<int> BulkInsertAsync<T>(LoginDTO LoginDTO, string sql, IEnumerable<T> items);

//          IAsyncEnumerable<T> ExecuteQueryAsync<T>(LoginDTO LoginDTO, string sql, object parameters = null);

//        Task<IEnumerable<TReturn>> QueryAsync<TFirst, TSecond, TReturn>(
//    LoginDTO loginDTO,
//    string sql,
//    Func<TFirst, TSecond, TReturn> map,
//    object parameters = null,
//    string splitOn = "Id");
//        Task<IEnumerable<TReturn>> QueryAsyncnew<TFirst, TSecond, TReturn>(
//           LoginDTO loginDTO,
//           string sql,
//           Func<TFirst, TSecond, TReturn> map,
//           object parameters = null,
//           string splitOn = "Id");


//    }
//}