public void MemberTest3() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralLargeItem LargeItemA = new GeneralLargeItem { //LargeObject = LargeObjectA, Culture = 1024, CLOB = "this is a test LargeItem", FileType = ".txt", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE, ObjUrl = "/123/23/3" }; GeneralLargeItem LargeItemB = new GeneralLargeItem { //LargeObject = LargeObjectB, Culture = 2011, CLOB = "this is the other test LargeItem", FileType = ".php", Source = (byte)ModelEnum.LargeObjectSource.NONE, ObjUrl = "/1abc" }; GeneralLargeObject LargeObjectA = new GeneralLargeObject { Code = "LargeObjectA", Culture = 1033, CLOB = "this is a LargeObject CLOB", FileType = ".jpg", ObjUrl = "/zhuchao/123", LargeItems = new List<GeneralLargeItem> { LargeItemA, LargeItemB}, Source = (byte)ModelEnum.LargeObjectSource.DATEBASE }; oLiveEntities.GeneralLargeObjects.Add(LargeObjectA); oLiveEntities.SaveChanges(); //Console.WriteLine(LargeItemA.Gid); //Console.WriteLine(LargeObjectA.Gid); oLiveEntities.Dispose(); GC.Collect(); }
private static void Test03() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); // 指定Child方式 GeneralLargeItem oItemA1 = new GeneralLargeItem { Culture = 1033, CLOB = "hello, this is a long text (en-US)", Source = (byte)ModelEnum.LargeObjectSource.NONE }; GeneralLargeItem oItemA2 = new GeneralLargeItem { Culture = 1036, CLOB = "hello, this is a long text (fr-FR)", Source = (byte)ModelEnum.LargeObjectSource.NONE }; GeneralLargeObject oLargeA = new GeneralLargeObject { CLOB = "hello, there are parents", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE, LargeItems = new List<GeneralLargeItem> { oItemA1, oItemA2 } }; // 指定Parent方式 GeneralLargeObject oLargeB = new GeneralLargeObject { CLOB = "hello, there are parents", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE }; GeneralLargeItem oItemB1 = new GeneralLargeItem { Culture = 1033, CLOB = "hello, this is a long text (en-US)", Source = (byte)ModelEnum.LargeObjectSource.NONE, LargeObject = oLargeB }; GeneralLargeItem oItemB2 = new GeneralLargeItem { Culture = 1036, CLOB = "hello, this is a long text (fr-FR)", Source = (byte)ModelEnum.LargeObjectSource.NONE, LargeObject = oLargeB }; oGeneralEntities.GeneralLargeObjects.Add(oLargeA); oGeneralEntities.GeneralLargeItems.Add(oItemB1); oGeneralEntities.GeneralLargeItems.Add(oItemB2); oGeneralEntities.SaveChanges(); var oResources = oGeneralEntities.GeneralLargeObjects.Include("GeneralLargeItems"); foreach (GeneralLargeObject obj1 in oResources.ToList()) { Console.WriteLine(obj1.CLOB); foreach (GeneralLargeItem obj2 in obj1.LargeItems) { CultureInfo oCulture = new CultureInfo(obj2.Culture); Console.WriteLine(" " + oCulture.NativeName + " " + obj2.CLOB); } } oGeneralEntities.Dispose(); GC.Collect(); }
/// <summary> /// 测试方法,最终废弃不用 /// </summary> /// <returns></returns> public ViewResult TestEditLargeMatter() { GeneralLargeItem item = new GeneralLargeItem { Culture = 1033, CLOB = "<p style='color:Green'>English</p>", }; GeneralLargeObject obj = new GeneralLargeObject { Culture = 2052, CLOB = "<p style='color:Red'>中文</p>", LargeItems = new List<GeneralLargeItem> { item } }; dbEntity.GeneralLargeObjects.Add(obj); dbEntity.SaveChanges(); return View(obj); }