這篇文章起源於我的LLBL Gen 3.x ORM源碼追蹤系列教程,有以下幾篇文章LLBL Gen 3.x 原始碼追蹤與解析 認識架構結構LLBL Gen 3.x 原始碼追蹤與解析 Type Converter 類型轉換器LLBL Gen 3.x 原始碼追蹤與解析 預存程序的執行LLBL Gen 3.x 原始碼追蹤與解析 查詢命令的追蹤LLBL Gen 3.x 原始碼追蹤與解析 驗證Validation的原理和流程ERP/MIS開發 開發LLBL Gen 外掛程式(Plun-in)
if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#table') and type='U') DROP TABLE #table CREATE TABLE #table ( [RECNUM] [decimal](28, 0) IDENTITY(1, 1) NOT NULL , ModuleCode NVARCHAR(30) COLLATE
select db_name() as CONSTRAINT_CATALOG,t_obj.name as TABLE_NAME,user_name(c_obj.uid) as CONSTRAINT_SCHEMA,c_obj.name as CONSTRAINT_NAME,col.name as COLUMN_NAME,col.colid as ORDINAL_POSITION,com.text as DEFAULT_CLAUSEfrom sysobjects c_objjoin
I wanted to update an entity with LLGLGen Pro by executing the adapter.SaveEntity() method and got an exception. ErrorAn exception was caught during the execution of an action query: Cannot insert duplicate key row in object ‘dbo.Customer’ with
I have recently been developing an application that uses LLBLGen with a vendor product SQL Server database. When attempting to add an entity, I was presented with the following exception:SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException
-- 資料庫表結構詳細資料查看 select [name] 表名,'' 欄位名,'' 資料類型,'' 實際長度,'' 欄位特性,'' 欄位序號,'' 是否自增列,'' 是否計算資料行 ,isnull((select value from sys.extended_properties p where p.name= 'MS_Description' and p.class='1' and p.major_id = o.id and p.minor_id=0 ), '') as 備忘 from
No.moduleparameter_iddescriptionvalue1AR EDIT_SYSTEM_INVOICE Allowed to edit system generated invoiceNO2GB LOT_CONTROL Enabled Lot ControlNO3GB QUOTENOW_EXPORT_ITEMExport Item Master to Quote NowNO4GB SERIAL_NO_CONTROL Enabled Serial No.