/// <summary>
/// Initializes a new instance of the <see cref="CopyOriginalCustomerNotesToFirstNote"/> class.
/// </summary>
public CopyOriginalCustomerNotesToFirstNote()
: base(ApplicationContext.Current.DatabaseContext.SqlSyntax, Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration())
{
var dbContext = ApplicationContext.Current.DatabaseContext;
_database = dbContext.Database;
_sqlSyntax = dbContext.SqlSyntax;
_noteService = MerchelloContext.Current.Services.NoteService;
}
/// <summary>
/// Initializes a new instance of the <see cref="AddInvoiceCurrencyCodeColumn"/> class.
/// </summary>
public AddInvoiceCurrencyCodeColumn()
: base(ApplicationContext.Current.DatabaseContext.SqlSyntax,
Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration())
{
var dbContext = ApplicationContext.Current.DatabaseContext;
_database = dbContext.Database;
_sqlSyntax = dbContext.SqlSyntax;
_invoiceService = (InvoiceService)MerchelloContext.Current.Services.InvoiceService;
}
/// <summary>
/// Initializes a new instance of the <see cref="CoreBootManager"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntaxProvider">
/// The <see cref="ISqlSyntaxProvider"/>.
/// </param>
internal CoreBootManager(ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider)
{
Mandate.ParameterNotNull(logger, "Logger");
Mandate.ParameterNotNull(sqlSyntaxProvider, "sqlSyntaxProvider");
_logger = logger;
_sqlSyntaxProvider = sqlSyntaxProvider;
SetUnitOfWorkProvider();
}
/// <summary>
/// Initializes a new instance of the <see cref="CoreMigrationManager"/> class.
/// </summary>
/// <param name="database">
/// The database.
/// </param>
/// <param name="sqlSyntaxProvider">
/// The SQL Syntax Provider.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
public CoreMigrationManager(Database database, ISqlSyntaxProvider sqlSyntaxProvider, ILogger logger)
{
Mandate.ParameterNotNull(database, "database");
Mandate.ParameterNotNull(sqlSyntaxProvider, "sqlSyntaxProvider");
Mandate.ParameterNotNull(logger, "logger");
_database = database;
_sqlSyntaxProvider = sqlSyntaxProvider;
_logger = logger;
}
/// <summary>
/// Initializes a new instance of the <see cref="MerchelloDatabaseSchemaHelper"/> class.
/// </summary>
/// <param name="db">
/// The DB.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="syntaxProvider">
/// The syntax provider.
/// </param>
internal MerchelloDatabaseSchemaHelper(Database db, ILogger logger, ISqlSyntaxProvider syntaxProvider)
{
Mandate.ParameterNotNull(db, "db");
Mandate.ParameterNotNull(logger, "logger");
Mandate.ParameterNotNull(syntaxProvider, "syntaxProvider");
_db = db;
_logger = logger;
_syntaxProvider = syntaxProvider;
this._umbSchemaHelper = new DatabaseSchemaHelper(db, logger, syntaxProvider);
}
//[TestFixtureSetUp]
public void Init()
{
var syntax = (DbSyntax)Enum.Parse(typeof(DbSyntax), ConfigurationManager.AppSettings["syntax"]);
// sets up the Umbraco SqlSyntaxProvider Singleton
SqlSyntaxProviderTestHelper.EstablishSqlSyntax(syntax);
_sqlSyntax = SqlSyntaxProviderTestHelper.SqlSyntaxProvider(syntax);
//AutoMapperMappings.CreateMappings();
_logger = Logger.CreateWithDefaultLog4NetConfiguration();
_database = new PetaPocoUnitOfWorkProvider(_logger).GetUnitOfWork().Database;
}
/// <summary>
/// Initializes a new instance of the <see cref="RepositoryFactory"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public RepositoryFactory(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(ApplicationContext.Current.ApplicationCache, logger, sqlSyntax)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="PaymentService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax
/// </param>
/// <param name="appliedPaymentService">
/// The applied payment service.
/// </param>
internal PaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax, IAppliedPaymentService appliedPaymentService)
: this(new RepositoryFactory(logger, sqlSyntax), logger, appliedPaymentService)
{
}
public CreateSensitiveDataUserGroup(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="RepositoryFactory"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public RepositoryFactory(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(false, new NullCacheProvider(), new ObjectCacheRuntimeCacheProvider(), logger, sqlSyntax)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="ItemCacheService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public ItemCacheService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
public AlterSyntaxBuilder(IMigrationContext context, ISqlSyntaxProvider sqlSyntax, params DatabaseProviders[] databaseProviders)
{
_context = context;
_sqlSyntax = sqlSyntax;
_databaseProviders = databaseProviders;
}
public EasyADRepository(UmbracoDatabase database, ISqlSyntaxProvider sqlSyntax)
{
_database = database;
_sqlSyntax = sqlSyntax;
}
public AddUserStartNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
public CreateInitialTables(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
_schemaHelper = new DatabaseSchemaHelper(_database, logger, sqlSyntax);
}
public ModelToSqlExpressionVisitor(ISqlSyntaxProvider sqlSyntax, IMapperCollection mappers)
: base(sqlSyntax)
{
_mappers = mappers;
_mapper = mappers[typeof(T)]; // throws if not found
}
public ContentPreviewRepository(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax)
: base(work, cache, logger, sqlSyntax)
{
}
public InitialMigration(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
this.databaseSchema = new DatabaseSchemaHelper(this.database, logger, sqlSyntax);
}
/// <summary>
/// Initializes a new instance of the <see cref="CreateDatabase"/> class.
/// </summary>
/// <param name="database">
/// The database.
/// </param>
/// <param name="sqlSyntaxProvider">
/// The sql Syntax Provider.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
internal CreateDatabase(Database database, ISqlSyntaxProvider sqlSyntaxProvider, ILogger logger)
{
_database = database;
_logger = logger;
_schemaHelper = new MerchelloDatabaseSchemaHelper(database, logger, sqlSyntaxProvider);
}
public RemoveStylesheetDataAndTablesAgain(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="PagedRepositoryBase{TEntity,TDto}"/> class.
/// </summary>
/// <param name="work">
/// The work.
/// </param>
/// <param name="cache">
/// The cache.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL Syntax.
/// </param>
protected PagedRepositoryBase(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax)
: base(work, cache, logger, sqlSyntax)
{
}
public UpdateToNewMemberPropertyAliases(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="AddTaxMethodColumn"/> class.
/// </summary>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
public AddTaxMethodColumn(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
_sqlSyntaxProvider = ApplicationContext.Current.DatabaseContext.SqlSyntax;
_databaseSchemaHelper = new DatabaseSchemaHelper(ApplicationContext.Current.DatabaseContext.Database, Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration(), _sqlSyntaxProvider);
}
/// <summary>
/// Gets the tag SQL used to retrieve paged posts for particular tags for a given articulate root node
/// </summary>
/// <param name="selectCols"></param>
/// <param name="masterModel"></param>
/// <param name="sqlSyntax"></param>
/// <param name="publishedDatePropertyTypeId">
/// This is needed to perform the sorting on published date, this is the PK of the property type for publishedDate on the ArticulatePost content type
/// </param>
/// <returns></returns>
/// <remarks>
/// TODO: We won't need this when this is fixed http://issues.umbraco.org/issue/U4-9290
/// </remarks>
private static Sql GetContentByTagQueryForPaging(string selectCols, IMasterModel masterModel, ISqlSyntaxProvider sqlSyntax, int publishedDatePropertyTypeId)
{
var sql = new Sql()
.Select(selectCols)
.From("umbracoNode")
.InnerJoin("cmsDocument")
.On("cmsDocument.nodeId = umbracoNode.id")
.InnerJoin("cmsPropertyData")
.On("cmsPropertyData.versionId = cmsDocument.versionId")
.Where("umbracoNode.nodeObjectType = @nodeObjectType", new { nodeObjectType = Constants.ObjectTypes.Document })
//Must be published, this will ensure there's only one version selected
.Where("cmsDocument.published = 1")
//must only return rows with the publishedDate property data so we only get one row and so we can sort on `cmsPropertyData.dataDate` which will be the publishedDate
.Where("cmsPropertyData.propertytypeid = @propTypeId", new { propTypeId = publishedDatePropertyTypeId })
//only get nodes underneath the current articulate root
.Where("umbracoNode." + sqlSyntax.GetQuotedColumnName("path") + " LIKE @path", new { path = masterModel.RootBlogNode.Path + ",%" });
return(sql);
}
/// <summary>
/// Initializes a new instance of the <see cref="AnonymousCustomerService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public AnonymousCustomerService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(logger, new RepositoryFactory(logger, sqlSyntax))
{
}
public static Sql GroupBy <TColumn>(this Sql sql, Expression <Func <TColumn, object> > columnMember, ISqlSyntaxProvider sqlProvider)
{
var column = ExpressionHelper.FindProperty(columnMember) as PropertyInfo;
var columnName = column.FirstAttribute <ColumnAttribute>().Name;
return(sql.GroupBy(sqlProvider.GetQuotedColumnName(columnName)));
}
/// <summary>
/// Gets the basic tag SQL used to retrieve tags for a given articulate root node
/// </summary>
/// <param name="selectCols"></param>
/// <param name="masterModel"></param>
/// <param name="sqlSyntax"></param>
/// <returns></returns>
/// <remarks>
/// TODO: We won't need this when this is fixed http://issues.umbraco.org/issue/U4-9290
/// </remarks>
private static Sql GetTagQuery(string selectCols, IMasterModel masterModel, ISqlSyntaxProvider sqlSyntax)
{
var sql = new Sql()
.Select(selectCols)
.From("cmsTags")
.InnerJoin("cmsTagRelationship")
.On("cmsTagRelationship.tagId = cmsTags.id")
.InnerJoin("cmsContent")
.On("cmsContent.nodeId = cmsTagRelationship.nodeId")
.InnerJoin("umbracoNode")
.On("umbracoNode.id = cmsContent.nodeId")
.Where("umbracoNode.nodeObjectType = @nodeObjectType", new {nodeObjectType = Constants.ObjectTypes.Document})
//only get nodes underneath the current articulate root
.Where("umbracoNode." + sqlSyntax.GetQuotedColumnName("path") + " LIKE @path", new {path = masterModel.RootBlogNode.Path + ",%"});
return sql;
}
public RepositoryFactory(
bool disableAllCache,
IRuntimeCacheProvider nullCacheProvider,
IRuntimeCacheProvider runtimeCacheProvider,
ILogger logger,
ISqlSyntaxProvider sqlSyntaxProvider)
: this(ApplicationContext.Current.ApplicationCache, logger, sqlSyntaxProvider)
{
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="work"></param>
/// <param name="cacheHelper"></param>
/// <param name="logger"></param>
/// <param name="sqlSyntax"></param>
/// <param name="passwordConfiguration">
/// A dictionary specifying the configuration for user passwords. If this is null then no password configuration will be persisted or read.
/// </param>
public UserRepository(IScopeUnitOfWork work, CacheHelper cacheHelper, ILogger logger, ISqlSyntaxProvider sqlSyntax,
IDictionary <string, string> passwordConfiguration = null)
: base(work, cacheHelper, logger, sqlSyntax)
{
_passwordConfiguration = passwordConfiguration;
}
public UpdateAllowedMediaTypesAtRoot(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="CustomerAddressService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public CustomerAddressService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
internal AddIndexToUmbracoNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger, bool skipIndexCheck) : base(sqlSyntax, logger)
{
_skipIndexCheck = skipIndexCheck;
}
/// <summary>
/// Initializes a new instance of the <see cref="RepositoryFactory"/> class.
/// </summary>
/// <param name="cache">
/// The cache.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntaxProvider">
/// The sql syntax provider.
/// </param>
internal RepositoryFactory(CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider)
{
_cacheHelper = cache;
_logger = logger;
_sqlSyntax = sqlSyntaxProvider;
}
public AddIndexToUmbracoNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="StoreSettingService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public StoreSettingService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
public UpdateDataExpression(DatabaseProviders current, DatabaseProviders[] databaseProviders, ISqlSyntaxProvider sqlSyntax)
: base(current, databaseProviders, sqlSyntax)
{
}
public LocalMigrationContext(DatabaseProviders databaseProvider, Database database, ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(databaseProvider, database, logger)
{
_sqlSyntax = sqlSyntax;
}
/// <summary>
/// Initializes a new instance of the <see cref="AppliedPaymentService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The sql syntax.
/// </param>
public AppliedPaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(logger, new RepositoryFactory(logger, sqlSyntax))
{
}
/// <summary>
/// Initializes a new instance of the <see cref="StoreSettingService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public StoreSettingService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
public AddSprintProgressTablePk(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="AddRedirectPaymentMethodType"/> class.
/// </summary>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
public AddRedirectPaymentMethodType(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
var dbContext = ApplicationContext.Current.DatabaseContext;
_database = dbContext.Database;
}
public EnsureAppsTreesUpdated(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="ProductVariantService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public ProductVariantService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
public DataTypeDefinitionRepository(IDatabaseUnitOfWork work, CacheHelper cache, CacheHelper cacheHelper, ILogger logger, ISqlSyntaxProvider sqlSyntax,
IContentTypeRepository contentTypeRepository)
: base(work, cache, logger, sqlSyntax)
{
_cacheHelper = cacheHelper;
_contentTypeRepository = contentTypeRepository;
_preValRepository = new DataTypePreValueRepository(work, CacheHelper.CreateDisabledCacheHelper(), logger, sqlSyntax);
}
/// <summary>
/// Initializes a new instance of the <see cref="WebMigrationManager"/> class.
/// </summary>
/// <param name="database">
/// The database.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <remarks>
/// Used for testing
/// </remarks>
internal WebMigrationManager(Database database, ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(database, sqlSyntax, logger)
{
}
public DataTypePreValueRepository(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax)
: base(work, cache, logger, sqlSyntax)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="RepositoryFactory"/> class.
/// </summary>
/// <param name="disableAllCache">
/// The disable all cache.
/// </param>
/// <param name="nullCacheProvider">
/// The null cache provider.
/// </param>
/// <param name="runtimeCacheProvider">
/// The runtime cache provider.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntaxProvider">
/// The SQL syntax provider.
/// </param>
public RepositoryFactory(
bool disableAllCache,
IRuntimeCacheProvider nullCacheProvider,
IRuntimeCacheProvider runtimeCacheProvider,
ILogger logger,
ISqlSyntaxProvider sqlSyntaxProvider)
{
_disableAllCache = disableAllCache;
_nullCacheProvider = nullCacheProvider;
_runtimeCacheProvider = runtimeCacheProvider;
_logger = logger;
_sqlSyntax = sqlSyntaxProvider;
}
public AlterTagsTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="WebBootManager"/> class.
/// Constructor for unit tests, ensures some resolvers are not initialized
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The <see cref="ISqlSyntaxProvider"/>
/// </param>
/// <param name="isForTesting">
/// The is For Testing.
/// </param>
internal WebBootManager(ILogger logger, ISqlSyntaxProvider sqlSyntax, bool isForTesting = false)
: base(logger, sqlSyntax)
{
_isForTesting = isForTesting;
}
public DeleteIndexExpression(DatabaseProviders current, DatabaseProviders[] databaseProviders, ISqlSyntaxProvider sqlSyntax)
: base(current, databaseProviders, sqlSyntax)
{
Index = new IndexDefinition();
}
/// <summary>
/// Initializes a new instance of the <see cref="DatabaseSchemaCreation"/> class.
/// </summary>
/// <param name="database">
/// The database.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="databaseSchemaHelper">
/// The database Schema Helper.
/// </param>
public DatabaseSchemaCreation(Database database, ILogger logger, DatabaseSchemaHelper databaseSchemaHelper, ISqlSyntaxProvider sqlSyntax)
{
_database = database;
_logger = logger;
_umbSchemaHelper = databaseSchemaHelper;
_sqlSyntax = sqlSyntax;
}
public LanguageRepository(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax)
: base(work, cache, logger, sqlSyntax)
{
}
public AddRegexToRedirectsTable(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
public AddTourDataUserColumn(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="PaymentService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
public PaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(logger, sqlSyntax, new AppliedPaymentService(logger, sqlSyntax))
{
}
/// <summary>
/// Initializes a new instance of the <see cref="ShipmentService"/> class.
/// </summary>
/// <param name="logger">
/// The logger.
/// </param>
/// <param name="sqlSyntax">
/// The sql syntax.
/// </param>
public ShipmentService(ILogger logger, ISqlSyntaxProvider sqlSyntax)
: this(new RepositoryFactory(logger, sqlSyntax), logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="MerchelloMigrationBase"/> class.
/// </summary>
/// <param name="sqlSyntax">
/// The SQL syntax.
/// </param>
/// <param name="logger">
/// The logger.
/// </param>
protected MerchelloMigrationBase(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
public NormalizeTemplateGuids(ISqlSyntaxProvider sqlSyntax, ILogger logger)
: base(sqlSyntax, logger)
{
}
public AddMissingForeignKeyForContentType(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger)
{
}
public static Sql OrderByDescending <TColumn>(this Sql sql, Expression <Func <TColumn, object> > columnMember, ISqlSyntaxProvider sqlSyntax)
{
var column = ExpressionHelper.FindProperty(columnMember) as PropertyInfo;
var columnName = column.FirstAttribute <ColumnAttribute>().Name;
var type = typeof(TColumn);
var tableNameAttribute = type.FirstAttribute <TableNameAttribute>();
string tableName = tableNameAttribute == null ? string.Empty : tableNameAttribute.Value;
var syntax = string.Format("{0}.{1} DESC",
sqlSyntax.GetQuotedTableName(tableName),
sqlSyntax.GetQuotedColumnName(columnName));
return(sql.OrderBy(syntax));
}
