public void StringNullToEmpty() { using (var fsql = new FreeSql.FreeSqlBuilder() .UseConnectionString(FreeSql.DataType.Oracle, "user id=1user;password=123456;data source=//127.0.0.1:1521/XE;Pooling=true;Max Pool Size=5;min pool size=1") .UseAutoSyncStructure(true) //.UseGenerateCommandParameterWithLambda(true) .UseLazyLoading(true) .UseNameConvert(FreeSql.Internal.NameConvertType.ToUpper) //.UseNoneCommandParameter(true) .UseMonitorCommand( cmd => Trace.WriteLine("\r\n线程" + Thread.CurrentThread.ManagedThreadId + ": " + cmd.CommandText) //监听SQL命令对象,在执行前 //, (cmd, traceLog) => Console.WriteLine(traceLog) ) .Build()) { var repo = fsql.GetRepository <TS_SL361, long>(); var item1 = new TS_SL361 { CreatorId = "" }; repo.Insert(item1); var item2 = repo.Get(item1.Id); Assert.Null(item2.CreatorId); fsql.Aop.AuditDataReader += (_, e) => { if (e.DataReader.GetFieldType(e.Index) == typeof(string) && e.Value == DBNull.Value) { e.Value = ""; } }; item1 = new TS_SL361 { CreatorId = "" }; repo.Insert(item1); item2 = repo.Get(item1.Id); Assert.Equal(item1.CreatorId, item2.CreatorId); fsql.Aop.AuditDataReader -= fsql.Aop.AuditDataReaderHandler; item1 = new TS_SL361 { CreatorId = "" }; repo.Insert(item1); item2 = repo.Get(item1.Id); Assert.Null(item2.CreatorId); } }
public void StringLength36() { var repo = g.oracle.GetRepository <TS_SL361, long>(); var item1 = new TS_SL361 { CreatorId = "xxx '123 " }; repo.Insert(item1); var item2 = repo.Get(item1.Id); Assert.Equal(item1.CreatorId, item2.CreatorId); }