C#(CSharp)/Etc31 Which is best LINQ or SQL queries? I'm assuming that you are referring to LINQ-to-SQL when you mean LINQ, which is basically using LINQ syntax to create and query your databases much like you would using SQL.I would recommend checking out this Stack Overflow discussion, which covers some of the advantages of using LINQ-to-SQL such as : No magic strings, like you have in SQL queriesIntellisenseCompile check when database changesFa.. 2018. 2. 4. Populate data table from data reader You can load a DataTable directly from a data reader using the Load() method that accepts an IDataReader.var dataReader = cmd.ExecuteReader(); var dataTable = new DataTable(); dataTable.Load(dataReader); SOURCE : https://stackoverflow.com/questions/18961938/populate-data-table-from-data-reader 2018. 2. 2. TraceListener C# Logging using Trace and DebugView 1)https://msdn.microsoft.com/en-us/library/system.diagnostics.tracelistener(v=vs.110).aspx 2)http://www.c-sharpcorner.com/uploadfile/puranindia/tracelistener-classes-in-c-sharp/ 3)http://dickvdbrink.github.io/c%23/2015/01/09/CSharp-Logging-using-Trace-and-DebugView.html https://docs.microsoft.com/en-us/dotnet/framework/debug-trace-profile/how-to-create-initia.. 2017. 12. 7. Simple and Powerful Debug function public static void TraceMessage(string message, [CallerMemberName] string memberName = "", [CallerFilePath] string sourceFilePath = "", [CallerLineNumber] int sourceLineNumber = 0) { Debug.WriteLine("message: " + message); Debug.WriteLine("member name: " + memberName); Debug.WriteLine("source file path: " + sourceFilePath); Debug.WriteLine("source line number: " + sourceLineNumber); } 2017. 10. 18. 이전 1 2 3 4 5 6 7 8 다음