netxdiy
- 浏览: 679042 次
- 性别:
- 来自: 上海
-
最新评论
-
TheUniqueGirl：
Tomcat系统架构与设计模式：http://www.doci ...
Tomcat -
aykjy：
...
UML常见工具之NetBeans(downmoon) -
不老肖邦：
谢谢提供的简单示例
JAVA toString（）
Reader转化为Entity类时系统性能的测试报告(downmoon原创)
在最常见的用法中，从Reader到Entity或Collection或List时总会用到对象转化。
这里提供一份简陋的性能测试报告(仅代表downmoon或邀月)的观点。
一、在测试之前，首先准备一个表(SQL2005）
Database Name :TestBigData
Table:Product
这里，提供一些傻瓜语句
<!-- <br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->
create
database
Testbigdata
go
use
Testbigdata
GO
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
IF
NOT
EXISTS
(
SELECT
*
FROM
sys.objects
WHERE
object_id
=
OBJECT_ID
(N
'
[dbo].[Product]
'
)
AND
type
in
(N
'
U
'
))
BEGIN
CREATE
TABLE
[
dbo
]
.
[
Product
]
(
[
P_ID
]
[
bigint
]
IDENTITY
(
1
,
1
)
NOT
NULL
,
[
P_Name
]
[
nvarchar
]
(
255
)
NULL
,
[
P_E_ID
]
[
int
]
NULL
,
[
CategoryID1
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__04AFB25B
]
DEFAULT
((
0
)),
[
CategoryID2
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__05A3D694
]
DEFAULT
((
0
)),
[
CategoryID3
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__0697FACD
]
DEFAULT
((
0
)),
[
CategoryID4
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__078C1F06
]
DEFAULT
((
0
)),
[
CategoryID5
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__0880433F
]
DEFAULT
((
0
)),
[
CategoryID6
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__09746778
]
DEFAULT
((
0
)),
[
P_SysCate
]
[
nvarchar
]
(
20
)
NULL
,
[
P_Key
]
[
nvarchar
]
(
100
)
NULL
,
[
P_SellArea
]
[
nvarchar
]
(
500
)
NULL
,
[
P_SingleIntro
]
[
nvarchar
]
(
1000
)
NULL
,
[
P_Intro
]
[
ntext
]
NULL
,
[
P_Order
]
[
float
]
NULL
,
[
P_Cate
]
[
nvarchar
]
(
20
)
NULL
,
[
P_Cate1
]
[
int
]
NULL
,
[
P_Cate2
]
[
int
]
NULL
,
[
P_Cate3
]
[
int
]
NULL
,
[
P_C_Order
]
[
int
]
NULL
,
[
P_TopTime
]
[
smalldatetime
]
NULL
,
[
AddTime
]
[
datetime
]
NULL
,
[
AddUser
]
[
nvarchar
]
(
50
)
NULL
,
[
ModTime
]
[
datetime
]
NULL
,
[
ModUser
]
[
nvarchar
]
(
50
)
NULL
,
[
P_BigImage
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage
]
[
nvarchar
]
(
150
)
NULL
,
[
P_BigImage2
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage2
]
[
nvarchar
]
(
150
)
NULL
,
[
P_BigImage3
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage3
]
[
nvarchar
]
(
150
)
NULL
,
[
LoginID
]
[
nvarchar
]
(
50
)
NULL
,
[
CurState
]
[
smallint
]
NOT
NULL
CONSTRAINT
[
DF__Product__CurStat__0A688BB1
]
DEFAULT
((
0
)),
[
RecState
]
[
smallint
]
NOT
NULL
CONSTRAINT
[
DF_Product_RecCtate
]
DEFAULT
((
0
)),
[
P_CheckInfo
]
[
nvarchar
]
(
80
)
NULL
,
[
P_Max
]
[
nvarchar
]
(
30
)
NULL
,
[
P_Min
]
[
nvarchar
]
(
30
)
NULL
,
[
P_Unit
]
[
nvarchar
]
(
50
)
NULL
,
[
P_L_ID
]
[
int
]
NULL
,
[
C_ID
]
[
int
]
NULL
,
[
C_I_ID
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__C_I_ID__0B5CAFEA
]
DEFAULT
((
0
)),
[
P_NewInfo
]
[
nvarchar
]
(
1000
)
NULL
,
[
P_Price
]
[
nvarchar
]
(
50
)
NULL
,
[
P_OtherState
]
[
int
]
NULL
,
[
P_NewKey1
]
[
nvarchar
]
(
300
)
NULL
,
[
P_NewKey2
]
[
nvarchar
]
(
300
)
NULL
,
[
P_NewKey3
]
[
nvarchar
]
(
300
)
NULL
,
[
F1
]
[
int
]
NOT
NULL
CONSTRAINT
[
DF__Product__F1__0C50D423
]
DEFAULT
((
0
)),
[
F2
]
[
int
]
NOT
NULL
CONSTRAINT
[
DF__Product__F2__0D44F85C
]
DEFAULT
((
0
)),
[
F3
]
[
nvarchar
]
(
50
)
NULL
,
[
F4
]
[
nvarchar
]
(
200
)
NULL
,
[
WebSite
]
[
nvarchar
]
(
50
)
NULL
,
[
Languages
]
[
nvarchar
]
(
20
)
NULL
,
CONSTRAINT
[
PK_PRODUCT
]
PRIMARY
KEY
CLUSTERED
(
[
P_ID
]
ASC
)
WITH
(PAD_INDEX
=
OFF
,STATISTICS_NORECOMPUTE
=
OFF
,IGNORE_DUP_KEY
=
OFF
,ALLOW_ROW_LOCKS
=
ON
,ALLOW_PAGE_LOCKS
=
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
TEXTIMAGE_ON
[
PRIMARY
]
END
SET
Identity_Insert
dbo.Product
ON
INSERT
INTO
dbo.Product(
P_ID,P_Name,P_E_ID,CategoryID1,
CategoryID2,CategoryID3,CategoryID4,CategoryID5,
CategoryID6,P_SysCate,P_Key,P_SellArea,
P_SingleIntro,P_Intro,P_Order,P_Cate,
P_Cate1,P_Cate2,P_Cate3,P_C_Order,
P_TopTime,AddTime,AddUser,ModTime,
ModUser,P_BigImage,P_SmallImage,P_BigImage2,
P_SmallImage2,P_BigImage3,P_SmallImage3,LoginID,
CurState,RecState,P_CheckInfo,P_Max,
P_Min,P_Unit,P_L_ID,C_ID,
C_I_ID,P_NewInfo,P_Price,P_OtherState,
P_NewKey1,P_NewKey2,P_NewKey3,F1,
F2,F3,F4,WebSite,
Languages)
VALUES
(
262144
,
'
成功1号
'
,
0
,
4
,
9
,
332
,
0
,
0
,
0
,
'
花椰菜
'
,
'
花菜种子，花椰菜种子，白花菜种子
'
,
'
1
'
,
'
花椰菜种子,特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，
'
,
'
<P>
特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，脚特短，节间特别紧密，芯叶多层扭卷护球。部份叶柄嵌入花球
下方，使花球成圆球形，花球三叠，特别洁白坚实紧密，质地柔嫩，鲜美可口，比重特大。一般单花球重2-3千克左右，适应性广，耐运输，还是冷冻出口创汇的
好原料。元旦前上市。结球期适应温度7-10℃。</P>
<P> 栽
培要点：该品种适宜北纬31℃以内种植。浙江省一般7月下旬播种为宜，其它地区敬请参照当地气候与栽培习惯，慎选最佳播期。一般南稍迟、北稍早；沿海平原
稍迟、内陆山区稍早。苗期适当遮荫，搭架避雨，苗龄25-30天（包括假植时间）。合理密植，每亩1400-1500株。施足基肥，成活后淡肥勤施，花球
形成后（时）重施追肥2-3次。及时摘叶盖花，生长期间要防治病虫害和结球期鼠害。
<BR> 播种期间不适，苗期过长，肥水管理跟不上，遇到天气长期高温晴旱或
暴雨淋伤根系都会提早形成花球，球小品质差。严重时容易出现毛花、异花（畸形花）。要照样施肥水，有利于增加产量，提高质量。</P>
'
,
0
,
'
Seed
'
,
20
,
0
,
0
,
0
,
'
2008-02-2800:00:00.000
'
,
'
2004-10-0917:37:00.000
'
,
NULL
,
'
2008-03-1319:35:59.140
'
,
'
qbd
'
,
'
20064201105007754.jpg
'
,
'
20064201105004166.jpg
'
,
''
,
''
,
''
,
''
,
'
qingyiseeds
'
,
1
,
0
,
''
,
''
,
''
,
'
千克/公斤
'
,
0
,
10633
,
0
,
''
,
''
,
0
,
'
花菜种子，花椰菜种子，白花菜种子
'
,
''
,
''
,
0
,
0
,
''
,
''
,
'
agronet
'
,
'
cn
'
)
GO
Set
Identity_Insert
dbo.Product
OFF
假定己插入2048条记录
二、创建ConSole Application
主要三个类如下：
最常见的用法：
<!-- <br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->
using
System;
using
System.Data.SqlClient;
namespace
DownmoonTestConsole
{
public
class
ManualBuilder
{
public
Agronet.Product.Framework.Components.ProductBuild(SqlDataReaderreader)
{
Agronet.Product.Framework.Components.Productm_Product
=
new
Agronet.Product.Framework.Components.Product();
if
(reader[
"
P_ID
"
]
!=
DBNull.Value)
{m_Product.P_ID
=
Convert.ToInt64(reader[
"
P_ID
"
]);}
if
(reader[
"
P_Name
"
]
!=
DBNull.Value)
{m_Product.P_Name
=
Convert.ToString(reader[
"
P_Name
"
]);}
if
(reader[
"
P_E_ID
"
]
!=
DBNull.Value)
{m_Product.P_E_ID
=
Convert.ToInt32(reader[
"
P_E_ID
"
]);}
if
(reader[
"
CategoryID1
"
]
!=
DBNull.Value)
{m_Product.CategoryID1
=
Convert.ToInt32(reader[
"
CategoryID1
"
]);}
if
(reader[
"
CategoryID2
"
]
!=
DBNull.Value)
{m_Product.CategoryID2
=
Convert.ToInt32(reader[
"
CategoryID2
"
]);}
if
(reader[
"
CategoryID3
"
]
!=
DBNull.Value)
{m_Product.CategoryID3
=
Convert.ToInt32(reader[
"
CategoryID3
"
]);}
if
(reader[
"
CategoryID4
"
]
!=
DBNull.Value)
{m_Product.CategoryID4
=
Convert.ToInt32(reader[
"
CategoryID4
"
]);}
if
(reader[
"
CategoryID5
"
]
!=
DBNull.Value)
{m_Product.CategoryID5
=
Convert.ToInt32(reader[
"
CategoryID5
"
]);}
if
(reader[
"
CategoryID6
"
]
!=
DBNull.Value)
{m_Product.CategoryID6
=
Convert.ToInt32(reader[
"
CategoryID6
"
]);}
if
(reader[
"
P_SysCate
"
]
!=
DBNull.Value)
{m_Product.P_SysCate
=
Convert.ToString(reader[
"
P_SysCate
"
]);}
if
(reader[
"
P_Key
"
]
!=
DBNull.Value)
{m_Product.P_Key
=
Convert.ToString(reader[
"
P_Key
"
]);}
if
(reader[
"
P_SellArea
"
]
!=
DBNull.Value)
{m_Product.P_SellArea
=
Convert.ToString(reader[
"
P_SellArea
"
]);}
if
(reader[
"
P_SingleIntro
"
]
!=
DBNull.Value)
{m_Product.P_SingleIntro
=
Convert.ToString(reader[
"
P_SingleIntro
"
]);}
if
(reader[
"
P_Intro
"
]
!=
DBNull.Value)
{m_Product.P_Intro
=
Convert.ToString(reader[
"
P_Intro
"
]);}
if
(reader[
"
P_Order
"
]
!=
DBNull.Value)
{m_Product.P_Order
=
Convert.ToDouble(reader[
"
P_Order
"
]);}
if
(reader[
"
P_Cate
"
]
!=
DBNull.Value)
{m_Product.P_Cate
=
Convert.ToString(reader[
"
P_Cate
"
]);}
if
(reader[
"
P_Cate1
"
]
!=
DBNull.Value)
{m_Product.P_Cate1
=
Convert.ToInt32(reader[
"
P_Cate1
"
]);}
if
(reader[
"
P_Cate2
"
]
!=
DBNull.Value)
{m_Product.P_Cate2
=
Convert.ToInt32(reader[
"
P_Cate2
"
]);}
if
(reader[
"
P_Cate3
"
]
!=
DBNull.Value)
{m_Product.P_Cate3
=
Convert.ToInt32(reader[
"
P_Cate3
"
]);}
if
(reader[
"
P_C_Order
"
]
!=
DBNull.Value)
{m_Product.P_C_Order
=
Convert.ToInt32(reader[
"
P_C_Order
"
]);}
if
(reader[
"
P_TopTime
"
]
!=
DBNull.Value)
{m_Product.P_TopTime
=
Convert.ToDateTime(reader[
"
P_TopTime
"
]);}
if
(reader[
"
P_BigImage
"
]
!=
DBNull.Value)
{m_Product.P_BigImage
=
Convert.ToString(reader[
"
P_BigImage
"
]);}
if
(reader[
"
P_SmallImage
"
]
!=
DBNull.Value)
{m_Product.P_SmallImage
=
Convert.ToString(reader[
"
P_SmallImage
"
]);}
if
(reader[
"
P_BigImage2
"
]
!=
DBNull.Value)
{m_Product.P_BigImage2
=
Convert.ToString(reader[
"
P_BigImage2
"
]);}
if
(reader[
"
P_SmallImage2
"
]
!=
DBNull.Value)
{m_Product.P_SmallImage2
=
Convert.ToString(reader[
"
P_SmallImage2
"
]);}
if
(reader[
"
P_BigImage3
"
]
!=
DBNull.Value)
{m_Product.P_BigImage3
=
Convert.ToString(reader[
"
P_BigImage3
"
]);}
if
(reader[
"
P_SmallImage3
"
]
!=
DBNull.Value)
{m_Product.P_SmallImage3
=
Convert.ToString(reader[
"
P_SmallImage3
"
]);}
if
(reader[
"
LoginID
"
]
!=
DBNull.Value)
{m_Product.LoginID
=
Convert.ToString(reader[
"
LoginID
"
]);}
if
(reader[
"
CurState
"
]
!=
DBNull.Value)
{m_Product.CurState
=
Convert.ToInt16(reader[
"
CurState
"
]);}
if
(reader[
"
RecState
"
]
!=
DBNull.Value)
{m_Product.RecState
=
Convert.ToInt16(reader[
"
RecState
"
]);}
if
(reader[
"
P_CheckInfo
"
]
!=
DBNull.Value)
{m_Product.P_CheckInfo
=
Convert.ToString(reader[
"
P_CheckInfo
"
]);}
if
(reader[
"
P_Max
"
]
!=
DBNull.Value)
{m_Product.P_Max
=
Convert.ToString(reader[
"
P_Max
"
]);}
if
(reader[
"
P_Min
"
]
!=
DBNull.Value)
{m_Product.P_Min
=
Convert.ToString(reader[
"
P_Min
"
]);}
if
(reader[
"
P_Unit
"
]
!=
DBNull.Value)
{m_Product.P_Unit
=
Convert.ToString(reader[
"
P_Unit
"
]);}
if
(reader[
"
P_L_ID
"
]
!=
DBNull.Value)
{m_Product.P_L_ID
=
Convert.ToInt32(reader[
"
P_L_ID
"
]);}
if
(reader[
"
C_ID
"
]
!=
DBNull.Value)
{m_Product.C_ID
=
Convert.ToInt32(reader[
"
C_ID
"
]);}
if
(reader[
"
C_I_ID
"
]
!=
DBNull.Value)
{m_Product.C_I_ID
=
Convert.ToInt32(reader[
"
C_I_ID
"
]);}
if
(reader[
"
P_NewInfo
"
]
!=
DBNull.Value)
{m_Product.P_NewInfo
=
Convert.ToString(reader[
"
P_NewInfo
"
]);}
if
(reader[
"
P_Price
"
]
!=
DBNull.Value)
{m_Product.P_Price
=
Convert.ToString(reader[
"
P_Price
"
]);}
if
(reader[
"
P_OtherState
"
]
!=
DBNull.Value)
{m_Product.P_OtherState
=
Convert.ToInt32(reader[
"
P_OtherState
"
]);}
if
(reader[
"
P_NewKey1
"
]
!=
DBNull.Value)
{m_Product.P_NewKey1
=
Convert.ToString(reader[
"
P_NewKey1
"
]);}
if
(reader[
"
P_NewKey2
"
]
!=
DBNull.Value)
{m_Product.P_NewKey2
=
Convert.ToString(reader[
"
P_NewKey2
"
]);}
if
(reader[
"
P_NewKey3
"
]
!=
DBNull.Value)
{m_Product.P_NewKey3
=
Convert.ToString(reader[
"
P_NewKey3
"
]);}
if
(reader[
"
AddTime
"
]
!=
DBNull.Value)
{m_Product.AddTime
=
Convert.ToDateTime(reader[
"
AddTime
"
]);}
if
(reader[
"
AddUser
"
]
!=
DBNull.Value)
{m_Product.AddUser
=
Convert.ToString(reader[
"
AddUser
"
]);}
if
(reader[
"
ModTime
"
]
!=
DBNull.Value)
{m_Product.ModTime
=
Convert.ToDateTime(reader[
"
ModTime
"
]);}
if
(reader[
"
ModUser
"
]
!=
DBNull.Value)
{m_Product.ModUser
=
Convert.ToString(reader[
"
ModUser
"
]);}
if
(reader[
"
F1
"
]
!=
DBNull.Value)
{m_Product.F1
=
Convert.ToInt32(reader[
"
F1
"
]);}
if
(reader[
"
F2
"
]
!=
DBNull.Value)
{m_Product.F2
=
Convert.ToInt32(reader[
"
F2
"
]);}
if
(reader[
"
F3
"
]
!=
DBNull.Value)
{m_Product.F3
=
Convert.ToString(reader[
"
F3
"
]);}
if
(reader[
"
F4
"
]
!=
DBNull.Value)
{m_Product.F4
=
Convert.ToString(reader[
"
F4
"
]);}
if
(reader[
"
WebSite
"
]
!=
DBNull.Value)
{m_Product.WebSite
=
Convert.ToString(reader[
"
WebSite
"
]);}
if
(reader[
"
Languages
"
]
!=
DBNull.Value)
{m_Product.Languages
=
Convert.ToString(reader[
"
Languages
"
]);}
return
m_Product;
}
}
}
第二种用法(Reflect)：
<!-- <br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->
using
System;
using
System.Data.SqlClient;
using
System.Reflection;
namespace
DynamicMappingSpike
{
public
class
ReflectionBuilder
<
T
>
{
private
PropertyInfo[]properties;
private
ReflectionBuilder()
{}
public
TBuild(SqlDataReaderreader)
{
Tresult
=
(T)Activator.CreateInstance(
typeof
(T));
for
(
int
i
=
0
;i
<
reader.FieldCount;i
++
)
{
if
(properties[i]
!=
null
&&
!
reader.IsDBNull(i))
{
properties[i].SetValue(result,reader[i],
null
);
}
}
return
result;
}
public
static
ReflectionBuilder
<
T
>
CreateBuilder(SqlDataReaderreader)
{
ReflectionBuilder
<
T
>
result
=
new
ReflectionBuilder
<
T
>
();
result.properties
=
new
PropertyInfo[reader.FieldCount];
for
(
int
i
=
0
;i
<
reader.FieldCount;i
++
)
{
result.properties[i]
=
typeof
(T).GetProperty(reader.GetName(i));
}
return
result;
}
}
}
第三种用法(DynaMicmethod ,基于IL）
<!-- <br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->
using
System;
using
System.Data.SqlClient;
using
System.Reflection;
using
System.Reflection.Emit;
using
System.Data;
namespace
DownmoonTestConsole
{
public
class
DynamicBuilder
<
T
>
{
private
static
readonly
MethodInfogetValueMethod
=
typeof
(IDataRecord).GetMethod(
"
get_Item
"
,
new
Type[]
{
typeof
(
int
)}
);
private
static
readonly
MethodInfoisDBNullMethod
=
typeof
(IDataRecord).GetMethod(
"
IsDBNull
"
,
new
Type[]
{
typeof
(
int
)}
);
private
delegate
TLoad(IDataRecorddataRecord);
private
Loadhandler;
private
DynamicBuilder()
{}
public
TBuild(IDataRecorddataRecord)
{
return
handler(dataRecord);
}
public
static
DynamicBuilder
<
T
>
CreateBuilder(IDataRecorddataRecord)
{
DynamicBuilder
<
T
>
dynamicBuilder
=
new
DynamicBuilder
<
T
>
();
DynamicMethodmethod
=
new
DynamicMethod(
"
DynamicCreate
"
,
typeof
(T),
new
Type[]
{
typeof
(IDataRecord)}
,
typeof
(T),
true
);
ILGeneratorgenerator
=
method.GetILGenerator();
LocalBuilderresult
=
generator.DeclareLocal(
typeof
(T));
generator.Emit(OpCodes.Newobj,
typeof
(T).GetConstructor(Type.EmptyTypes));
generator.Emit(OpCodes.Stloc,result);
for
(
int
i
=
0
;i
<
dataRecord.FieldCount;i
++
)
{
PropertyInfopropertyInfo
=
typeof
(T).GetProperty(dataRecord.GetName(i));
LabelendIfLabel
=
generator.DefineLabel();
if
(propertyInfo
!=
null
&&
propertyInfo.GetSetMethod()
!=
null
)
{
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4,i);
generator.Emit(OpCodes.Callvirt,isDBNullMethod);
generator.Emit(OpCodes.Brtrue,endIfLabel);
generator.Emit(OpCodes.Ldloc,result);
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4,i);
generator.Emit(OpCodes.Callvirt,getValueMethod);
generator.Emit(OpCodes.Unbox_Any,dataRecord.GetFieldType(i));
generator.Emit(OpCodes.Callvirt,propertyInfo.GetSetMethod());
generator.MarkLabel(endIfLabel);
}
}
generator.Emit(OpCodes.Ldloc,result);
generator.Emit(OpCodes.Ret);
dynamicBuilder.handler
=
(Load)method.CreateDelegate(
typeof
(Load));
return
dynamicBuilder;
}
}
}
基于的实体类
<!-- <br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> -->
using
System;
namespace
Agronet.Product.Framework.Components
{
Product
#region
Product
public
class
Product
{
private
long
m_P_ID;
/**/
///
<summary>
///
产品ID
///
</summary>
public
long
P_ID
{
get
{
return
m_P_ID;}
set
{m_P_ID
=
value;}
}
private
string
m_P_Name;
/**/
///
<summary>
///
产品名称
///
</summary>
public
string
P_Name
{
get
{
return
m_P_Name;}
set
{m_P_Name
=
value;}
}
private
int
m_P_E_ID;
/**/
///
<summary>
///
分类扩展属性ID
///
</summary>
public
int
P_E_ID
{
get
{
return
m_P_E_ID;}
set
{m_P_E_ID
=
value;}
}
private
int
m_CategoryID1;
/**/
///
<summary>
///
产品产业分类
///
</summary>
public
int
CategoryID1
{
get
{
return
m_CategoryID1;}
set
{m_CategoryID1
=
value;}
}
private
int
m_CategoryID2;
/**/
///
<summary>
///
产品行业分类
///
</summary>
public
int
CategoryID2
{
get
{
return
m_CategoryID2;}
set
{m_CategoryID2
=
value;}
}
private
int
m_CategoryID3;
/**/
///
<summary>
///
第三分类ID
///
</summary>
public
int
CategoryID3
{
get
{
return
m_CategoryID3;}
set
{m_CategoryID3
=
value;}
}
private
int
m_CategoryID4;
/**/
///
<summary>
///
第四分类ID
///
</summary>
public
int
CategoryID4
{
get
{
return
m_CategoryID4;}
set
{m_CategoryID4
=
value;}
}
private
int
m_CategoryID5;
/**/
///
<summary>
///
第五分类ID
///
</summary>
public
int
CategoryID5
{
get
{
return
m_CategoryID5;}
set
{m_CategoryID5
=
value;}
}
private
int
m_CategoryID6;
/**/
///
<summary>
///
第六分类ID
///
</summary>
public
int
CategoryID6
{
get
{
return
m_CategoryID6;}
set
{m_CategoryID6
=
value;}
}
private
string
m_P_SysCate;
/**/
///
<summary>
///
系统分类(旧）
///
</summary>
public
string
P_SysCate
{
get
{
return
m_P_SysCate;}
set
{m_P_SysCate
=
value;}
}
private
string
m_P_Key;
/**/
///
<summary>
///
关键字
///
</summary>
public
string
P_Key
{
get
{
return
m_P_Key;}
set
{m_P_Key
=
value;}
}
private
string
m_P_SellArea;
/**/
///
<summary>
///
产品销售地区
///
</summary>
public
string
P_SellArea
{
get
{
return
m_P_SellArea;}
set
{m_P_SellArea
=
value;}
}
private
string
m_P_SingleIntro;
/**/
///
<summary>
///
简介
///
</summary>
public
string
P_SingleIntro
{
get
{
return
m_P_SingleIntro;}
set
{m_P_SingleIntro
=
value;}
}
private
string
m_P_Intro;
/**/
///
<summary>
///
介绍
///
</summary>
public
string
P_Intro
{
get
{
return
m_P_Intro;}
set
{m_P_Intro
=
value;}
}
private
double
m_P_Order;
/**/
///
<summary>
///
排序
///
</summary>
public
double
P_Order
{
get
{
return
m_P_Order;}
set
{m_P_Order
=
value;}
}
private
string
m_P_Cate;
/**/
///
<summary>
///
分类(旧)
///
</summary>
public
string
P_Cate
{
get
{
return
m_P_Cate;}
set
{m_P_Cate
=
value;}
}
private
int
m_P_Cate1;
/**/
///
<summary>
///
产品原分类1
///
</summary>
public
int
P_Cate1
{
get
{
return
m_P_Cate1;}
set
{m_P_Cate1
=
value;}
}
private
int
m_P_Cate2;
/**/
///
<summary>
///
产品原分类2
///
</summary>
public
int
P_Cate2
{
get
{
return
m_P_Cate2;}
set
{m_P_Cate2
=
value;}
}
private
int
m_P_Cate3;
/**/
///
<summary>
///
产品原分类3
///
</summary>
public
int
P_Cate3
{
get
{
return
m_P_Cate3;}
set
{m_P_Cate3
=
value;}
}
private
int
m_P_C_Order;
/**/
///
<summary>
///
企业顺序
///
</summary>
public
int
P_C_Order
{
get
{
return
m_P_C_Order;}
set
{m_P_C_Order
=
value;}
}
private
DateTimem_P_TopTime;
/**/
///
<summary>
///
置顶时间
///
</summary>
public
DateTimeP_TopTime
{
get
{
return
m_P_TopTime;}
set
{m_P_TopTime
=
value;}
}
private
DateTimem_AddTime;
/**/
///
<summary>
///
新增时间
///
</summary>
public
DateTimeAddTime
{
get
{
return
m_AddTime;}
set
{m_AddTime
=
value;}
}
private
string
m_AddUser;
/**/
///
<summary>
///
新增用户
///
</summary>
public
string
AddUser
{
get
{
return
m_AddUser;}
set
{m_AddUser
=
value;}
}
private
DateTimem_ModTime;
/**/
///
<summary>
///
修改时间
///
</summary>
public
DateTimeModTime
{
get
{
return
m_ModTime;}
set
{m_ModTime
=
value;}
}
private
string
m_ModUser;
/**/
///
<summary>
///
修改人
///
</summary>
public
string
ModUser
{
get
{
return
m_ModUser;}
set
{m_ModUser
=
value;}
}
private
string
m_P_BigImage;
/**/
///
<summary>
///
大图地址
///
</summary>
public
string
P_BigImage
{
get
{
return
m_P_BigImage;}
set
{m_P_BigImage
=
value;}
}
private
string
m_P_SmallImage;
/**/
///
<summary>
///
小图地址
///
</summary>
public
string
P_SmallImage
{
get
{
return
m_P_SmallImage;}
set
{m_P_SmallImage
=
value;}
}
private
string
m_P_BigImage2;
/**/
///
<summary>
///
大图地址2
///
</summary>
public
string
P_BigImage2
{
get
{
return
m_P_BigImage2;}
set
{m_P_BigImage2
=
value;}
}
private
string
m_P_SmallImage2;
/**/
///
<summary>
///
小图地址2
///
</summary>
public
string
P_SmallImage2
{
get
{
return
m_P_SmallImage2;}
set
{m_P_SmallImage2
=
value;}
}
private
string
m_P_BigImage3;
/**/
///
<summary>
///
大图地址3
///
</summary>
public
string
P_BigImage3
{
get
{
return
m_P_BigImage3;}
set
{m_P_BigImage3
=
value;}
}
private
string
m_P_SmallImage3;
/**/
///
<summary>
///
小图地址3
///
</summary>
public
string
P_SmallImage3
{
get
{
return
m_P_SmallImage3;}
set
{m_P_SmallImage3
=
value;}
}
private
string
m_LoginID;
/**/
///
<summary>
///
登录帐号
///
</summary>
public
string
LoginID
{
get
{
return
m_LoginID;}
set
{m_LoginID
=
value;}
}
private
short
m_CurState;
/**/
///
<summary>
///
审核状态
///
</summary>
public
short
CurState
{
get
{
return
m_CurState;}
set
{m_CurState
=
value;}
}
private
short
m_RecState;
/**/
///
<summary>
///
推荐状态
///
</summary>
public
short
RecState
{
get
{
return
m_RecState;}
set
{m_RecState
=
value;}
}
private
string
m_P_CheckInfo;
/**/
///
<summary>
///
审核信息
///
</summary>
public
string
P_CheckInfo
{
get
{
return
m_P_CheckInfo;}
set
{m_P_CheckInfo
=
value;}
}
private
string
m_P_Max;
/**/
///
<summary>
///
单价上限
///
</summary>
public
string
P_Max
{
get
{
return
m_P_Max;}
set
{m_P_Max
=
value;}
}
private
string
m_P_Min;
/**/
///
<summary>
///
单价下限
///
</summary>
public
string
P_Min
{
get
{
return
m_P_Min;}
set
{m_P_Min
=
value;}
}
private
string
m_P_Unit;
/**/
///
<summary>
///
单价单位
///
</summary>
public
string
P_Unit
{
get
{
return
m_P_Unit;}
set
{m_P_Unit
=
value;}
}
private
int
m_P_L_ID;
/**/
///
<summary>
///
商标ID
///
</summary>
public
int
P_L_ID
{
get
{
return
m_P_L_ID;}
set
{m_P_L_ID
=
value;}
}
private
int
m_C_ID;
/**/
///
<summary>
///
企业ID
///
</summary>
public
int
C_ID
{
get
{
return
m_C_ID;}
set
{m_C_ID
=
value;}
}
private
int
m_C_I_ID;
/**/
///
<summary>
///
联系方式ID
///
</summary>
public
int
C_I_ID
{
get
{
return
m_C_I_ID;}
set
{m_C_I_ID
=
value;}
}
private
string
m_P_NewInfo;
/**/
///
<summary>
///
扩展联系方式
///
</summary>
public
string
P_NewInfo
{
get
{
return
m_P_NewInfo;}
set
{m_P_NewInfo
=
value;}
}
private
string
m_P_Price;
/**/
///
<summary>
///
价格(旧)
///
</summary>
public
string
P_Price
{
get
{
return
m_P_Price;}
set
{m_P_Price
=
value;}
}
private
int
m_P_OtherState;
/**/
///
<summary>
///
其他状态
///
</summary>
public
int
P_OtherState
{
get
{
return
m_P_OtherState;}
set
{m_P_OtherState
=
value;}
}
private
string
m_P_NewKey1;
/**/
///
<summary>
///
新关键字一
///
</summary>
public
string
P_NewKey1
{
get
{
return
m_P_NewKey1;}
set
{m_P_NewKey1
=
value;}
}
private
string
m_P_NewKey2;
/**/
///
<summary>
///
新关键字二
///
</summary>
public
string
P_NewKey2
{
get
{
return
m_P_NewKey2;}
set
{m_P_NewKey2
=
value;}
}
private
string
m_P_NewKey3;
/**/
///
<summary>
///
新关键字三
///
</summary>
public
string
P_NewKey3
{
get
{
return
m_P_NewKey3;}
set
{m_P_NewKey3
=
value;}
}
private
int
m_F1;
/**/
///
<summary>
///
扩展1
///
</summary>
public
int
F1
{
get
{
return
m_F1;}
set
{m_F1
=
value;}
}
private
int
m_F2;
/**/
///
<summary>
///
扩展2
///
</summary>
public
int
F2
{
get
{
return
m_F2;}
set
{m_F2
=
value;}
}
private
string
m_F3;
/**/
///
<summary>
///
扩展3
///
</summary>
public
string
F3
{
get
{
return
m_F3;}
set
{m_F3
=
value;}
}
private
string
m_F4;
/**/
///
<summary>
///
扩展4
///
</summary>
public
string
F4
{
get
{
return
m_F4;}
set
{m_F4
=
value;}
}
private
string
m_WebSite;
/**/
///
<summary>
///
网站
///
</summary>
public
string
WebSite
{
get
{
return
m_WebSite;}
set
{m_WebSite
=
value;}
}
private
string
m_Languages;
/**/
///
<summary>
///
语言
///
</summary>
public
string
Languages
{
get
{
return
m_Languages;}
set
{m_Languages
=
value;}
}
}
#endregion
}
测试主要方法
在网络流量200的负载测试下
结果如图
结论 在vs2005环境下，从Reader流转化为List<T>或IList<T>时，Reflect方法效率最低，DynamicMethod次之，但性能与Manual方法相当接近，综合而言， DynamicMethod 代码量小，移植性好，性能相对也不错，值得推荐!
最主要的是：当Entity的属性值个数大于Reader的Column个数时，Reflect和DynamicMethod性能更佳，且不会报错！换言之，当你需取表中的某几个字段时，DynamicMwthod的优势是显而易见的！
分享到：
发表评论
相关推荐
entity, C++ 最小实体组件系统单头库 实体最小的实体组件系统。特性vt 。ECS标记和组基本事件处理安装在项目中包含 entity 文件夹。基础 0.包含实体#include "entity/World.hpp" 1.定义组件// not
WCF+Silverlight+EntityFramework+Sqlite所做的学生信息管理系统，自己闲暇时间做着玩的，页面什么的比较丑，不过不要在意那些细节……数据库采用Sqlite，非常小的一个数据库，我就不提供了，网上一大堆，表结构什么...
根据表结构字段生成实体类，private int? keyId; public int? KeyId{get{return keyId;} set{keyId=value;}}
在命令的最后它会提示我们创建个数据迁移，当我们使make:migration命令时，Symfony会查看我们所有的entity类，然后读取注解，再和数据库中对应
Cesium 中 实体类entity多种实例对象-实现点击事件
EntityFrameWork 6.x Respoistory Extensions，EF 6.x 仓储帮助扩展类，于2016-04-08封装完成，集成了常规CRUD，以及批量增删改和执行SQL操作，非常适合大家使用！
C# 进行AutoCAD二次开发时实现windows控件绘制AutoCAD图形实体Entity的类.cs
fastjson 1.2.47--json字符串与entity之间的转换，maven依赖代码，
Entity Framework 6 Recipes Entity Framework 6 Recipes
预备知识 2 LINQ技术 2 LINQ技术的基础 - C#3.0 2 自动属性 2 隐式类型 2 ...为什么要使用Entity Framework，限制条件及当前版本框架的问题 23 EDM中的DML 23 含有Association的EDM的使用 23
C#：此小程序实现将复杂的 json 格式数据转换为对应的实体类对象，对象与对象之间的关系采用了 ImplementFactory 组件提供的 Constraint 属性，可以在 Visual Studio 里使用 Nuget 搜索并引用该组件，该组件可实现...
ADO.NET Entity Framework 是微软以 ADO.NET 为基础所发展出来的对象关系对应 (O/R Mapping) 解决方案，早期被称为 ObjectSpace，现已经包含在 Visual Studio 2008 Service Pack 1 以及 .NET Framework 3.5 Service ...
Entity Framework Repository(含依赖注入)
Entity Developer Entity Developer Entity Developer
J2EE开发中，对照MySQL数据库中的表和字段，快速生成Java中的实体类的工具类，有助于快速开发。
Entity Developer是一个强大的ORM设计器，支持 ADO.NET Entity Framework, NHibernate, LinqConnect 和 LINQ to SQL。你可以使用模型首先和数据首先的方法设计ORM模型并生成C#或者Visual Basic .NET代码。它引入了新...
自留demo。springMVC-HttpEntity（ResponseEntity）与jQuery交互的小结demo。
本书是关于Entity framework code first 的详细介绍，在本书中，你可以学到从无到有的创建基于Entity framework code first的项目
Entity Framework Core Cookbook - Second Edition by Ricardo Peres English | 9 Nov. 2016 | ISBN: 1785883305 | 340 Pages | MOBI/EPUB/PDF+Code Files | 6.2 MB Entity Framework is a highly recommended ...
电子书 Entity Framework 4 In Action