1 強制關閉數據庫鏈接

--關閉用戶打開的進程處理 USE master go IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[p_killspid] go create proc p_killspid @dbname varchar(200) --要關閉進程的數據庫名 as declare @programName nvarchar(200), @spid nvarchar(20) declare cDblogin cursor for select cast(spid as varchar(20)) AS spid from master..sysprocesses where dbid=db_id(@dbname) open cDblogin fetch next from cDblogin into @spid while @@fetch_status=0 begin --防止自己終止自己的進程 --否則會報錯不能用KILL 來終止您自己的進程。 IF @spid <> @@SPID exec( 'kill '+@spid) fetch next from cDblogin into @spid end close cDblogin deallocate cDblogin go --用法 exec p_killspid 'fdoam' View Code

?2 數據庫鏈接字符創

第一種在遠程的：DBFirst: <add name="ZouminEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;
data source=169.254.22.8;initial catalog=PharmacySystem;user id=sa;password=pass01!;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /> 第二種在本地的 DBFirst:

<add name="ZouminEntities"connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;
data source=.;initial catalog=PharmacySystem;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;"providerName="System.Data.EntityClient"/>

sa登陸：
"Data Source=.;Initial Catalog=數據庫;User ID=sa,pwd=;";

windows登陸
Data Source=.;Initial Catalog=數據庫;Integrated Security=True

Code First

<add name="PharmacySystem" providerName="System.Data.SqlClient" connectionString="Data Source=169.254.22.8;Initial Catalog=PharmacySystem;Integrated Security=false;User ID=sa;Password=pass01!" />

?

?

轉載于:https://www.cnblogs.com/zoumin123/p/7641832.html

總結

以上是生活随笔為你收集整理的EF 学习 实用脚本的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。