private static void TestJsonLibraries(string[] testFilePathList)
{
using (var fileStream = new FileStream(
$"TestResults/DeserializationTestResult-{DateTime.Now.ToFileTime()}.csv",
FileMode.OpenOrCreate))
using (var writer = new StreamWriter(fileStream, Encoding.UTF8)) {
const int iteration = 10;
writer.WriteLine($"Deserialization Test (iteration: {iteration})");
writer.WriteLine("Unit: ms,FadeJson,Jil,JSON.NET,ServiceStack.Text,SimpleJson,jsonfx");
foreach (var filePath in testFilePathList)
{
writer.Write(Path.GetFileNameWithoutExtension(filePath));
var results = new[] {
CodeTimer.Execute($"FadeJson {filePath}", iteration,
() => { Json.FromFile(filePath); }),
CodeTimer.Execute($"Jil {filePath}", iteration,
() => { JSON.DeserializeDynamic(new StreamReader(filePath)); }),
CodeTimer.Execute($"JSON.NET {filePath}", iteration,
() => { JObject.Load(new JsonTextReader(new StreamReader(filePath))); }),
CodeTimer.Execute($"ServiceStack.Text {filePath}", iteration,
() => { DynamicJson.Deserialize(File.ReadAllText(filePath)); }),
CodeTimer.Execute($"jsonfx {filePath}", iteration,
() => { new JsonReader().Read(new StreamReader(filePath)); })
};
foreach (var result in results)
{
writer.Write($",{result.TimeElapsed}");
}
writer.WriteLine();
}
}
}
static void Main(string[] args)
{
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("name", 1) };
var ss = SqlSugarTool.GetParameters(sp);
CodeTimer.InitializeByConcurrent();
CodeTimerResult ret = CodeTimer.Execute("sugar", 1, new Action(() =>
{
using (SqlSugarClient db = new SqlSugarClient(System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer1"].ConnectionString))
{
//var list = db.GetDataTable("select * from AccountCode where AccountType=1", new { });
//var list = db.GetDataTable("select * from AccountCode where AccountType=@AccountType", new { AccountType = 1 });
var list = db.Queryable <AccountCodeModel1>("AccountCode").Where <AccountCodeModel1>(c => c.AccountType == 1).ToList();
int rowCount = list.Count;
}
}));
//Console.ReadKey();
}