📄 ref_types.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 7.0">
<TITLE>LLBLGen::SQLServer, .NET type relations</TITLE>
<link rel="STYLESHEET" type="text/css" href="general.css">
</HEAD>
<BODY>
<br>
<h3>LLBLGen::SQLServer, .NET type relations</h3>
<p>
The table below shows the relation between the type of a field in SQLServer and the effect this type
has on parts of the generated code by LLBLGen. Use this table to determine quick which type a property
has when you know the type of the field, corresponding with that property, in SQLServer. See also the
SqlTypes namespace help:
<a href="ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfSystemDataSqlTypes.htm">System.Data.SqlTypes Namespace (.NET SDK Docs)</a>. The
<i>LLBLGen default value</i> will be assigned to a field of that particular type when a field of that type is marked Excluded.
This assigning is done in the stored procedure, therefor the default value is given in T-SQL syntaxis.
<br><br clear="all">
<table border="1" cellpadding="3" cellspacing="0">
<tr bgcolor="LightGrey">
<td class="TDSmallerfont"><b>SQLServer type</b></td>
<td class="TDSmallerfont"><b>.NET Property type</b></td>
<td class="TDSmallerfont"><b>Type prefix</b></td>
<td class="TDSmallerfont"><b>LLBLGen default value</b></td>
</tr>
<tr>
<td class="TDSmallerFont">binary</td>
<td class="TDSmallerFont">SqlBinary</td>
<td class="TDSmallerFont">bi</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">bigint</td>
<td class="TDSmallerFont">SqlInt64</td>
<td class="TDSmallerFont">l</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">char</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">datetime</td>
<td class="TDSmallerFont">SqlDateTime</td>
<td class="TDSmallerFont">da</td>
<td class="TDSmallerFont">GETDATE()</td>
</tr>
<tr>
<td class="TDSmallerFont">decimal</td>
<td class="TDSmallerFont">SqlDecimal</td>
<td class="TDSmallerFont">dc</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">float</td>
<td class="TDSmallerFont">SqlDouble</td>
<td class="TDSmallerFont">f</td>
<td class="TDSmallerFont">0.0</td>
</tr>
<tr>
<td class="TDSmallerFont">image</td>
<td class="TDSmallerFont">SqlBinary</td>
<td class="TDSmallerFont">blob</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">int</td>
<td class="TDSmallerFont">SqlInt32</td>
<td class="TDSmallerFont">i</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">money</td>
<td class="TDSmallerFont">SqlMoney</td>
<td class="TDSmallerFont">cur</td>
<td class="TDSmallerFont">0.0</td>
</tr>
<tr>
<td class="TDSmallerFont">nchar</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">ntext</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">nvarchar</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">numeric</td>
<td class="TDSmallerFont">SqlDecimal</td>
<td class="TDSmallerFont">dc</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">real</td>
<td class="TDSmallerFont">SqlSingle</td>
<td class="TDSmallerFont">do</td>
<td class="TDSmallerFont">0.0</td>
</tr>
<tr>
<td class="TDSmallerFont">smalldatetime</td>
<td class="TDSmallerFont">SqlDateTime</td>
<td class="TDSmallerFont">da</td>
<td class="TDSmallerFont">GETDATE()</td>
</tr>
<tr>
<td class="TDSmallerFont">smallint</td>
<td class="TDSmallerFont">SqlInt16</td>
<td class="TDSmallerFont">si</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">smallmoney</td>
<td class="TDSmallerFont">SqlMoney</td>
<td class="TDSmallerFont">cur</td>
<td class="TDSmallerFont">0.0</td>
</tr>
<tr>
<td class="TDSmallerFont">sql_variant</td>
<td class="TDSmallerFont">Object</td>
<td class="TDSmallerFont">o</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">sysname</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">text</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">timestamp</td>
<td class="TDSmallerFont">SqlBinary</td>
<td class="TDSmallerFont">bi</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">tinyint</td>
<td class="TDSmallerFont">SqlByte</td>
<td class="TDSmallerFont">by</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">varbinary</td>
<td class="TDSmallerFont">SqlBinary</td>
<td class="TDSmallerFont">bi</td>
<td class="TDSmallerFont">0</td>
</tr>
<tr>
<td class="TDSmallerFont">varchar</td>
<td class="TDSmallerFont">SqlString</td>
<td class="TDSmallerFont">s</td>
<td class="TDSmallerFont">'' (empty string)</td>
</tr>
<tr>
<td class="TDSmallerFont">uniqueidentifier</td>
<td class="TDSmallerFont">SqlGuid</td>
<td class="TDSmallerFont">guid</td>
<td class="TDSmallerFont">NEWID()</td>
</tr>
</table>
<br clear="all">
</p>
<div align="right" class="SmallFontTOC">
<hr size="1" width="60%" align="right">
LLBLGen v1.21 documentation. © 2002-2003 <a href="http://www.sd.nl/" target="_blank">Solutions Design</a>
</div>
<br><br>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -