|
; //数据库用户密码，必须与数据库连接字符串中的用户密码一致
ApplicationConfiguration.DefaultPersistenceProperty=pp; //设置应用程序的默认配置属性
配置信息的说明如下：
1） 数据库连接字符串、用户名和密码的设置按照常规设置
2） MapFileLocationTye指明XML映射文件的路径类型，可以有三种类型:
a) AbsolutePath：采用绝对路径的形式，在这种情况下，MapFileLocation设置成绝对路径的形式，如：“d:\apppath\xml”。
b) VirtualPath：对于Web应用程序，可以设置为虚拟路径的形式，如“/MyWebApp/EntityDefinitions/”。
c) Assembly：XML文件作为资源文件被编译。采用这种形式，需要将XML文件的生成操作属性设置成“嵌入的资源”，这种情况下，MapFileLocation的格式为：“AssemblyName,NameSpace”。例如，XML文件位于WebsharpTestLib项目的xml文件夹下面，MapFileLocation可以设置为：“WebsharpTestLib,WebsharpTestLib.xml”
附1：Websharp主要接口定义：
PersistenceCapable：
public interface PersistenceCapable
{
EntityData EntityData{get;set;}
int ObjectCount{get;}
void AddNew();
bool Next();
void First();
}
PersistenceManager：
public interface PersistenceManager : IDisposable
{
void Close();
bool IsClosed{get;}
Transaction CurrentTransaction{ get;}
bool IgnoreCache{get;set;}
void PersistNewObject(EntityData entity);
void PersistNewObject(PersistenceCapable pc);
void UpdateObject(EntityData entity);
void UpdateObject(PersistenceCapable pc);
void DeleteObject(EntityData entity);
void DeleteObject(PersistenceCapable pc);
void Reload(EntityData entity);
void Reload(PersistenceCapable pc);
void Evict (object pc);
void EvictAll (object[] pcs);
void EvictAll (ICollection pcs);
void EvictAll ();
EntityData FindEntityDataByPrimaryKey(object id,string entityTypeName);
EntityData FindEntityDataByPrimaryKey(object id,EntityData entity);
PersistenceCapable FindObjectByPrimaryKey(object id,PersistenceCapable pc);
PersistenceCapable FindObjectByPrimaryKey(object id,Type entityType);
Query NewQuery();
Query NewQuery(string entityTypeName);
Query NewQuery(string entityTypeName,string filter);
Query NewQuery(string entityTypeName,string filter,QueryParameterCollection paramColletion);
DataAccess NewDataAccess();
}
Transaction：
public interface Transaction
{
void Begin();
void Commit();
void Rollback();
PersistenceManager PersistenceManager{get;}
}
Query：
public interface Query
{
string EntityTypeName{get;set;}
string Filter{get;set;}
QueryParameterCollection Parameters
{
get;
set;
}
string Ordering{get;set;}
bool IgnoreCache{get;set;}
EntityData QueryData();
PersistenceCapable QueryObject(PersistenceCapable ps);
EntityData LoadSubObject(EntityData entity,string subTypeName);
PersistenceCapable QueryObject(PersistenceCapable ps,string subTypeName);
EntityData LoadSubObjects(EntityData entity);
PersistenceManager PersistenceManager{get;}
bool QuerySubObjects{get;set;}
bool IsClosed{get;}
void Close ();
void Open();
}
DataAccess：
public interface DataAccess
{
#region Support Property & Method
DatabaseType DatabaseType{get;}
IDbConnection DbConnection{get;}
PersistenceManager PersistenceManager{get;}
IDbTransaction BeginTransaction();
void Open();
void Close();
bool IsClosed{get;}
#endregion
#region ExecuteNonQuery
int ExecuteNonQuery(CommandType commandType, string commandText);
int ExecuteNonQuery(string commandText);
int ExecuteNonQuery(string commandText, QueryParameterCollection commandParameters);
int ExecuteNonQuery(CommandType commandType, string commandText, QueryParameterCollection commandParameters);
#endregion ExecuteNonQuery
#region ExecuteDataSet
DataSet ExecuteDataset(CommandType commandType, string commandText);
DataSet ExecuteDataset(string commandText);
DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters);
DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters);
DataSet ExecuteDataset(CommandType commandType, string commandText,string tableName);
DataSet ExecuteDataset(string commandText,string tableName);
DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,string tableName);
DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,string tableName);
DataSet ExecuteDataset(CommandType commandType, string commandText,DataSet ds);
DataSet ExecuteDataset(string commandText,DataSet ds);
DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,DataSet ds);
DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,DataSet ds);
DataSet ExecuteDataset(CommandType commandType, string commandText,DataSet ds,string tableName);
DataSet ExecuteDataset(string commandText,DataSet ds,string tableName);
DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,DataSet ds,string tableName);
DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,DataSet ds,string tableName);
#endregion ExecuteDataSet
#region ExecuteReader
IDataReader ExecuteReader(CommandType commandType, string commandText);
IDataReader ExecuteReader(string commandText);
IDataReader ExecuteReader(CommandType commandType, string commandText, QueryParameterCollection commandParameters);
IDataReader ExecuteReader(string commandText, QueryParameterCollection commandParameters);
#endregion ExecuteReader
#region ExecuteScalar
object ExecuteScalar(CommandType commandType, string commandText);
object ExecuteScalar(string commandText);
object ExecuteScalar(CommandType commandType, string commandText, QueryParameterCollection commandParameters);
object ExecuteScalar(string commandText, QueryParameterCollection commandParameters);
#endregion ExecuteScalar
#region ExecuteXmlReader
XmlReader ExecuteXmlReader(CommandType commandType, string commandText);
XmlReader ExecuteXmlReader(string commandText);
XmlReader ExecuteXmlReader(CommandType commandType, string commandText, QueryParameterCollection commandParameters);
XmlReader ExecuteXmlReader(string commandText, QueryParameterCollection commandParameters);
#endregion ExecuteXmlReader
}
附2：使用Websharp中间件开发的Demo程序一份。
[6] [7] [8]
上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页
|
