حرفه ای: کاربرد sqldataProvider چیست؟ [بایگانی]

hmahdavi921

سه شنبه 15 دی 1394, 14:09 عصر

سلام
در پروژه ها یک فایل سی شارپ با این نام وجود داره .دلیل استفاده از این فایل رو میتونید بگید.
با تشکر

using System;
using DotNetNuke.Common.Utilities;
using DotNetNuke.Framework.Providers;

namespace Christoc.Modules.test_module_template.Data
{

/// -----------------------------------------------------------------------------
/// <summary>
/// SQL Server implementation of the abstract DataProvider class
///
/// This concreted data provider class provides the implementation of the abstract methods
/// from data dataprovider.cs
///
/// In most cases you will only modify the Public methods region below.
/// </summary>
/// -----------------------------------------------------------------------------
public class SqlDataProvider : DataProvider
{

#region Private Members

private const string ProviderType = "data";
private const string ModuleQualifier = "test_module_template_";

private readonly ProviderConfiguration _providerConfiguration = ProviderConfiguration.GetProviderConfiguration(Pro viderType);
private readonly string _connectionString;
private readonly string _providerPath;
private readonly string _objectQualifier;
private readonly string _databaseOwner;

#endregion

#region Constructors

public SqlDataProvider()
{

// Read the configuration specific information for this provider
Provider objProvider = (Provider)(_providerConfiguration.Providers[_providerConfiguration.DefaultProvider]);

// Read the attributes for this provider

//Get Connection string from web.config
_connectionString = Config.GetConnectionString();

if (string.IsNullOrEmpty(_connectionString))
{
// Use connection string specified in provider
_connectionString = objProvider.Attributes["connectionString"];
}

_providerPath = objProvider.Attributes["providerPath"];

_objectQualifier = objProvider.Attributes["objectQualifier"];
if (!string.IsNullOrEmpty(_objectQualifier) && _objectQualifier.EndsWith("_", StringComparison.Ordinal) == false)
{
_objectQualifier += "_";
}

_databaseOwner = objProvider.Attributes["databaseOwner"];
if (!string.IsNullOrEmpty(_databaseOwner) && _databaseOwner.EndsWith(".", StringComparison.Ordinal) == false)
{
_databaseOwner += ".";
}

}

#endregion

#region Properties

public string ConnectionString
{
get
{
return _connectionString;
}
}

public string ProviderPath
{
get
{
return _providerPath;
}
}

public string ObjectQualifier
{
get
{
return _objectQualifier;
}
}

public string DatabaseOwner
{
get
{
return _databaseOwner;
}
}

// used to prefect your database objects (stored procedures, tables, views, etc)
private string NamePrefix
{
get { return DatabaseOwner + ObjectQualifier + ModuleQualifier; }
}

#endregion

#region Private Methods

private static object GetNull(object field)
{
return Null.GetNull(field, DBNull.Value);
}

#endregion

#region Public Methods

//public override IDataReader GetItem(int itemId)
//{
// return SqlHelper.ExecuteReader(ConnectionString, NamePrefix + "spGetItem", itemId);
//}

//public override IDataReader GetItems(int userId, int portalId)
//{
// return SqlHelper.ExecuteReader(ConnectionString, NamePrefix + "spGetItemsForUser", userId, portalId);
//}

#endregion

}

}