<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ID_Dexter的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ID_Dexter</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ID_Dexter]]></copyright><item><title><![CDATA[记录SqlServer Tree递归查询]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/105660315</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/105660315</guid><author>ID_Dexter</author><pubDate>Tue, 21 Apr 2020 16:17:45 +0800</pubDate><description><![CDATA[菜单表t_Sys_Navigation

ID            主键ID

ParentID       父级ID

NavigationName 菜单名称

查询父节点（含父节点下所有子节点的集合）

WITH tree AS --创建一个虚拟表
 (
  SELECT Nav.ID ,
      Nav.Paren...]]></description><category></category></item><item><title><![CDATA[SqlServer表与表之间数据导入]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/105638639</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/105638639</guid><author>ID_Dexter</author><pubDate>Mon, 20 Apr 2020 17:00:24 +0800</pubDate><description><![CDATA[数据源表T_Source_A 字段valueA,valueB,valueC

导入表T_Destination_B

导入表T_Destination_B（存在）

Insert intoT_Source_A(valueA,valueB,valueC)(select valueA,valueB,valueC from T_Destination_B)

导入表T_Destination_B（不存...]]></description><category></category></item><item><title><![CDATA[解决SqlServer锁表]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/105358881</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/105358881</guid><author>ID_Dexter</author><pubDate>Tue, 07 Apr 2020 10:38:45 +0800</pubDate><description><![CDATA[选中存在锁表的库执行下面SQL语句

select  request_session_id  spid,OBJECT_NAME(resource_associated_entity_id) tableName 
from  sys.dm_tran_locks where resource_type='OBJECT'

查询锁表进程及表名

declare @spid int
Set ...]]></description><category></category></item><item><title><![CDATA[复制windows指令到linux虚拟机中]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/104797231</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/104797231</guid><author>ID_Dexter</author><pubDate>Wed, 11 Mar 2020 15:14:32 +0800</pubDate><description><![CDATA[首先确保gpm服务是关闭状态

在windows中Ctrl + C复制所选内容

打开虚拟机窗口，确保选中黑色窗体（或点击黑色窗体）

确保光标在虚拟机窗口之外（黑色窗体之外）用ctrl + v粘贴内容




...]]></description><category></category></item><item><title><![CDATA[.NetCore + EF + Mysql DBFirst映射实体]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/103511392</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/103511392</guid><author>ID_Dexter</author><pubDate>Thu, 12 Dec 2019 16:31:16 +0800</pubDate><description><![CDATA[引入Microsoft.EntityFrameworkCore.Tools +Pomelo.EntityFrameworkCore.MySql后

在程序包管理器控制台执行

Scaffold-DbContext “server=服务器地址;userid=登录名;pwd=密码;port=端口;database=数据名称;sslmode=none;” Pomelo.EntityFrameworkC...]]></description><category></category></item><item><title><![CDATA[关于Expression扩展ExpressionExtension的用法]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/102542515</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/102542515</guid><author>ID_Dexter</author><pubDate>Mon, 14 Oct 2019 10:22:49 +0800</pubDate><description><![CDATA[定义lambda表达式树形结构

Expression&lt;Func&lt;T, bool&gt;&gt; lambda = t =&gt; true;

定义查询条件

StartTime =2017/10/13 0:00:00

添加查询条件

lambda = lambda.And(t =&gt; t.StartTime &gt;StartTime);

对查询条件重新复制

Star...]]></description><category></category></item><item><title><![CDATA[关于ASP.NET Core + EF Core学习总结]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/100735401</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/100735401</guid><author>ID_Dexter</author><pubDate>Wed, 11 Sep 2019 14:52:36 +0800</pubDate><description><![CDATA[ASP.NET Core 目录结构

wwwroot用于存放静态文件，例如：JavaScript文件、图像图形、CSS样式表文件等

依赖项一般存放NuGet包和SDK

ASP.NET Core可以在Startup类中的Configure方法中通过添加中间件的方式实现不同功能，是一种装配到应用程序管道以处理请求和响应的组件。

UseDeveloperExceptionPage：用于请求进入...]]></description><category></category></item><item><title><![CDATA[SqlServer查看表结构语句]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/100667182</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/100667182</guid><author>ID_Dexter</author><pubDate>Mon, 09 Sep 2019 16:49:59 +0800</pubDate><description><![CDATA[SELECT CASE WHEN col.colorder = 1 THEN obj.name 
         ELSE '' 
      END AS 表名, 
    col.colorder AS 序号 , 
    col.name AS 列名 , 
    ISNULL(ep.[value], '') AS 列说明...]]></description><category></category></item><item><title><![CDATA[ef框架简单总结]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/90206089</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/90206089</guid><author>ID_Dexter</author><pubDate>Tue, 14 May 2019 14:49:44 +0800</pubDate><description><![CDATA[1.ef项目搭建完成后，引用该项目的配置文件要添加对应配置

&lt;connectionStrings&gt;

  &lt;add name="QYI_InHospitalEntities"    connectionString="metadata=res://*/EFTestModel.csdl|res://*/EFTestModel.ssdl|res://*/EFTestMo...]]></description><category></category></item><item><title><![CDATA[MVC控制器中获取本地IP]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/89948261</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/89948261</guid><author>ID_Dexter</author><pubDate>Wed, 08 May 2019 11:21:49 +0800</pubDate><description><![CDATA[/// &lt;summary&gt;
    /// MVC控制器中获取本地IP
    /// &lt;/summary&gt;
    /// &lt;returns&gt;&lt;/returns&gt;
    public static string GetLocalIP()
    {
      string ip = strin...]]></description><category></category></item><item><title><![CDATA[winform 影藏panel滚动条]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/89492957</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/89492957</guid><author>ID_Dexter</author><pubDate>Wed, 24 Apr 2019 14:49:46 +0800</pubDate><description><![CDATA[#region 设置滚动条是否显示

    [DllImport("user32.dll", CharSet = CharSet.Auto)]
    public static extern int ShowScrollBar(IntPtr hWnd, int bar, int show);


    private class SubWindow : NativeW...]]></description><category></category></item><item><title><![CDATA[this新用法，简化方法参数]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/89453505</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/89453505</guid><author>ID_Dexter</author><pubDate>Mon, 22 Apr 2019 15:57:19 +0800</pubDate><description><![CDATA[/// &lt;summary&gt;
    /// hashtable转化字符串
    /// &lt;/summary&gt;
    /// &lt;param name="ht"&gt;&lt;/param&gt;
    /// &lt;param name="key"&gt;&lt;/param&gt;
    /// &lt...]]></description><category></category></item><item><title><![CDATA[(转)C#为什么要使用Invoke,它和BeginInvoke有什么区别]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/89154865</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/89154865</guid><author>ID_Dexter</author><pubDate>Tue, 09 Apr 2019 17:00:58 +0800</pubDate><description><![CDATA[在Invoke或者BeginInvoke的使用中无一例外地使用了委托Delegate。


一、为什么Control类提供了Invoke和BeginInvoke机制？

关于这个问题的最主要的原因已经是dotnet程序员众所周知的，我在此费点笔墨再次记录到自己的日志，以便日后提醒一下自己。

1、windows程序消息机制

Windows GUI程序是基于消息机制的，有个主线程维护着一个消息泵...]]></description><category></category></item><item><title><![CDATA[Windows7中出现的KERNELBASE.dll错误的解决方法(转）]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/88998547</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/88998547</guid><author>ID_Dexter</author><pubDate>Wed, 03 Apr 2019 16:26:24 +0800</pubDate><description><![CDATA[在Windows7系统中，偶尔会出现这样的软件无法启动问题，详细信息是KERNELBASE.dll错误，一般不是KERNELBASE.dll的问题，也并不需要复制一个KERNELBASE.dll文件替换掉它，你只需要在桌面快捷方式或者安装目录里的软件图标→鼠标右击→属性→兼容性→以管理员身份运行此程序，即可解决问题。

...]]></description><category></category></item><item><title><![CDATA[EF模型下使用Linq语句引发在提供程序连接上启动事务时出错]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/83011582</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/83011582</guid><author>ID_Dexter</author><pubDate>Thu, 11 Oct 2018 14:10:20 +0800</pubDate><description><![CDATA[在EF下使用linq查询时没有将结果转换成list直接使用，会占用数据库连接，使后续的数据库操作引发异常。

var hardwareMonitor = (from monitor in db.T_Monit_HardwareMonitor
                                       group monitor by new
                   ...]]></description><category></category></item><item><title><![CDATA[安装和卸载已安装windows服务]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/81229008</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/81229008</guid><author>ID_Dexter</author><pubDate>Thu, 26 Jul 2018 22:45:41 +0800</pubDate><description><![CDATA[安装

1.安装时cmd要以以管理员身份运行

2.cd C:\Windows\Microsoft.NET\Framework\v4.0.30319（先确定改路径存在）

3.InstallUtil.exe D:\WindowsService.exe（windows服务的exe程序所在路径）

注：安装失败时可能会出现提示”服务错误1053:服务没有及时响应启动或控制请求“。可能原因

原因：开发...]]></description><category></category></item><item><title><![CDATA[Socket监听与TcpListener监听的区别和用法]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/80679735</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/80679735</guid><author>ID_Dexter</author><pubDate>Wed, 13 Jun 2018 15:38:12 +0800</pubDate><description><![CDATA[socket是针对应用层和传输层之间封装的接口Tcplistener是对socket tcp协议封装的接口，更便于开发1.利用Tcp协议编程1)服务器端：     a)建立TCP监听器TcpListener对象。                   TcpListener tl=new TcpListener(端口号);     b)启动监听器                    tl.Star...]]></description><category></category></item><item><title><![CDATA[数据库修改表属性无法保存]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/80538589</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/80538589</guid><author>ID_Dexter</author><pubDate>Fri, 01 Jun 2018 15:38:58 +0800</pubDate><description><![CDATA[选择  工具 →选项]]></description><category></category></item><item><title><![CDATA[简单的反射实例以及for循环和foreach差别]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/80450739</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/80450739</guid><author>ID_Dexter</author><pubDate>Fri, 25 May 2018 13:53:16 +0800</pubDate><description><![CDATA[重点：1.反射判断值类型          2.关于for循环和foreach的区别for循环可以修改循环中元素属性，而foreach不能，更不能对集合进行add和delete，原因是collection中返回的IEmumator设置其元素为只读属性，所以即使元素是int值类型也不能修改。这时最好使用for循环...]]></description><category></category></item><item><title><![CDATA[反射读取类中的各属性值（含嵌套）]]></title><link>https://blog.youkuaiyun.com/ID_Dexter/article/details/80336116</link><guid>https://blog.youkuaiyun.com/ID_Dexter/article/details/80336116</guid><author>ID_Dexter</author><pubDate>Wed, 16 May 2018 14:06:08 +0800</pubDate><description><![CDATA[    注：取值赋值时找好对应类]]></description><category></category></item></channel></rss>