ORM: 开发自己的Data Access Application Block - Part I
2008-12-06 10:15:45 来源:WEB开发网SimpleDbParameterNameMapping
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace Artech.ApplicationBlock.DataMapping
{
/**//// <summary>
/// SimpleDbParameterNameMapping defines a simple mapping method between the corresponding parameter name and source culumn name of the table.
/// </summary>
public class SimpleDbParameterNameMapping:IDbParameterNameMapping
{
IDbParameterNameMapping Members#region IDbParameterNameMapping Members
/**//// <summary>
/// Get the source column name based on the parameter name of the related stored procedure.
/// </summary>
/// <param name="patameterName">The parameter name of the corresponding stored procedure.</param>
/// <returns>The source column name corresponding to the parameter name.</returns>
public string GetSourceCoulmnName(string patameterName)
{
//@p_abc_def|o_abc_def=>ABC_DEF
return patameterName.Substring(3, patameterName.Length - 3).ToUpper();
}
/**//// <summary>
/// Get the source parameter name based on the source column name.
/// </summary>
/// <param name="columnName">The source column name corresponding to the parameter name.</param>
/// <param name="rowVersion">The data row version of the source solumn conressponding to the parameter.</param>
/// <returns>The parameter name of the corresponding stored procedure.</returns>
public string GetParameterName(string columnName, DataRowVersion rowVersion)
{
//ABC_DEF =>@p_abc_def|o_abc_def
string prefix = "@p";
if (rowVersion == DataRowVersion.Original)
{
prefix = "@o";
}
return string.Format("{0}_{1}", prefix, columnName.ToLowerInvariant());
}
#endregion
}
}
- ››开发Android 日历教程
- ››开发学院总结 Win 8实用技巧大全
- ››开发学院原创教程:把win8的IE10放桌面上方法(非...
- ››开发者眼中的Windows Phone和Android
- ››开发学院教你用SQL 语句最快速清空MySQL 数据表的...
- ››自己动手写iPhone wap浏览器之界面架构篇
- ››自己也能DIY个性真人QQ表情
- ››自己动手!巧法让酷狗动感歌词更完美
- ››自己编译Google Android内核的Linux源码
- ››自己写的一个jquery模板引擎(json比较好用)
- ››开发一个自己的HTML在线编辑器(一)
- ››开发一个自己的HTML在线编辑器(二)
更多精彩
赞助商链接