讓ASP.NET網站在開發除錯時期擁有WEB.CONFIG文件轉換功能

ref:
https://blog.kkbruce.net/2016/09/enabling-xml-document-transforms-for-all-asp-net-web-by-develop-time.html#.XoP1KGMzbRY

[EF]DB char? mapping to EF string

Equals('') or Equals("")

linq pad4
使用 Equals('0')


c#
Equals("0")
或是
PSex[0]=='0'




ref:
https://stackoverflow.com/questions/6760765/how-do-i-map-a-char-property-using-the-entity-framework-4-1-code-only-fluent-a

[JS]子字串包含

const string = "foo";
const substring = "oo";

console.log(string.includes(substring));

=======================================================

ie support

var string = "foo";
var substring = "oo";

console.log(string.indexOf(substring) !== -1);

https://stackoverflow.com/questions/1789945/how-to-check-whether-a-string-contains-a-substring-in-javascript

[closedXML]手動換行

 var ws2 = wb.Worksheets.Add(title + "列表與紀錄");

 mRStr = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";
 mRStr += "\r\n";
 mRStr  +="bbbbbbbbbbbbbbbbbbb";

  ws2.Cell(ws2_r_idx, ws2_c_idx).Value = mRStr;
  ws2.Cell(ws2_r_idx, ws2_c_idx).Style.Alignment.WrapText = true;


  ws2.Rows().AdjustToContents();
  ws2.Columns().AdjustToContents();

ref:
http://byeblou.blogspot.com/2018/11/c-excel-closedxml.html