I am i C#.net developer for a few years now... Last couple of months i have started to study design patterns and enterprise software architecture principles so that i will be able to use those principles in my code... Well here is actual example what i need. Right now i am developing asp.net web api REST services. My data is stored in mysql relational database. In data access layer i would like to use Dapper micro ORM, so i would like to create some kind of my own ORM wrapper methods...If i decide in the future to change to some other ORM that i wont need to rewrite my whole DAL layer code... Here is the code how i am planning to do this: What do you think about my approach?(my goal here is not to be technology(dapper) dependent...)
public abstract class BaseORMCommandSettings //SQL command base class
{
public string CommandText { get; private set; }
public object Parameters { get; private set; }
public IDbTransaction Transaction { get; private set; }
public int? CommandTimeout { get; private set; }
public CommandType? CommandType { get; private set; }
public CancellationToken CancellationToken { get; private set; }
public BaseORMCommandSettings(string commandText, object parameters = null, IDbTransaction transaction = null, int? commandTimeout = null,
CommandType? commandType = null, CancellationToken cancellationToken = default(CancellationToken))
{
this.CommandText = commandText;
this.Parameters = parameters;
this.Transaction = transaction;
this.CommandTimeout = commandTimeout;
this.CommandType = commandType;
this.CancellationToken = cancellationToken;
}
}
public class DapperCommandSettings : BaseORMCommandSettings//dapper cmd impl
{
public CommandFlags Flags { get; private set; }
public DapperCommandSettings(string commandText, object parameters = null, IDbTransaction transaction = null, int? commandTimeout = null,
CommandType? commandType = null, CancellationToken cancellationToken = default(CancellationToken), CommandFlags flags = CommandFlags.Buffered)
:base(commandText, parameters, transaction, commandTimeout, commandType, cancellationToken)
{
this.Flags = flags;
}
}
public interface ICustomORM //base interface, for now have only generic Read
list method
{
IEnumerable<T> Read<T>(BaseORMCommandSettings cmd);
}
public class DapperORM : ICustomORM //my own dapper ORM wrapper implentation
{
private readonly IDbConnection con;
public DapperORM(IDbConnection con)
{
this.con = con;
}
public IEnumerable<T> Read<T>(BaseORMCommandSettings cmd)
{
var cmdDapper = cmd as DapperCommandSettings;
var dapperCmd = new CommandDefinition(cmdDapper.CommandText, cmdDapper.Parameters, cmdDapper.Transaction,
cmdDapper.CommandTimeout, cmdDapper.CommandType, cmdDapper.Flags,
cmdDapper.CancellationToken);
return con.Query<T>(dapperCmd);
}
}
Thank's in advance for any kind of HELP!:)
regards
Aucun commentaire:
Enregistrer un commentaire