Database

MERGE [dbo].[Service_Program_Detail] AS T
USING (select *, @PK_Target 'PK_Target'  from [dbo].[Service_Program_Detail] 
        where FK_Program_Code_ServiceProgDetails = @PK_Source
        and FK_Fiscal_Period_Code_ServiceProgDetails=@Fiscal_Period_Code) AS S
ON ((T.FK_Service_Code_ServiceProgDetails = S.FK_Service_Code_ServiceProgDetails) 
    and (T.FK_Fiscal_Period_Code_ServiceProgDetails=S.FK_Fiscal_Period_Code_ServiceProgDetails)
    and (T.FK_Program_Code_ServiceProgDetails=S.PK_Target))
WHEN NOT MATCHED  
    THEN INSERT(FK_Service_Code_ServiceProgDetails, FK_Program_Code_ServiceProgDetails
    , FK_Fiscal_Period_Code_ServiceProgDetails, CreatedBy, ModifiedBy
    , CreatedOn, ModifiedOn, FK_Service_Program_Detail_Unit_Types)  
    VALUES(S.FK_Service_Code_ServiceProgDetails, S.PK_Target
    , S.FK_Fiscal_Period_Code_ServiceProgDetails, @ExecutedBy, @ExecutedBy,
    getdate(), getdate(), FK_Service_Program_Detail_Unit_Types)
WHEN MATCHED 
    THEN UPDATE SET T.FK_Service_Program_Detail_Unit_Types = S.FK_Service_Program_Detail_Unit_Types
    OUTPUT inserted.PK_Service_Program_Detail,   
     inserted.FK_Service_Code_ServiceProgDetails,
     @PK_Source,  
     inserted.FK_Program_Code_ServiceProgDetails,
     inserted.FK_Fiscal_Period_Code_ServiceProgDetails
    INTO @Service_Program_Detail
    (
        PK_Service_Program_Detail_T,
        FK_Service_Code_ServiceProgDetails,
        Program_Code_S,
        Program_Code_T,
        FK_Fiscal_Period_Code_ServiceProgDetails
    );

--Scripts to load test data
		
SELECT * INTO #UserAccount FROM (
SELECT 123 AS UserAccounts, 'I' AS AccountType, 1 AS BillingAccountKey
UNION ALL
SELECT 456, 'O', 2
UNION ALL
SELECT 789, 'O', 3
UNION ALL
SELECT 101, 'I', 4
UNION ALL
SELECT 102, 'O', 5) A

SELECT * FROM #UserAccount

--================================================================
		SELECT * INTO #BillingTransactions FROM (
SELECT 1 AS BillingTransactionKey,	1 AS BillingAccountKey,	111 AS BillingCode
UNION ALL
SELECT 2,	2,	222
UNION ALL
SELECT 3,	2,	333
UNION ALL
SELECT 4,	2,	444
UNION ALL
SELECT 5,	3,	111
UNION ALL
SELECT 6,	3,	555
UNION ALL
SELECT 7,	3,	666
UNION ALL
SELECT 8,	3,	222
UNION ALL
SELECT 9,	5,	333
UNION ALL
SELECT 10,	5,	777)A

SELECT * FROM #BillingTransactions

--===============================================
	SELECT * INTO #BillingCodeRank FROM(
SELECT 111 AS BillingCode,	7 AS [Rank]
UNION ALL
SELECT 222,	6
UNION ALL
SELECT 333,	5
UNION ALL
SELECT 444,	4
UNION ALL
SELECT 555,	3
UNION ALL
SELECT 666,	2
UNION ALL
SELECT 777,	1
UNION ALL
SELECT 888,	1
UNION ALL
SELECT 999,	3
UNION ALL
SELECT 101,	5)A
SELECT * FROM #BillingCodeRank

I am stuck in the middle of a project. I am having an issue with adding the data source in "Entity Data Model Wizard"

Navigation Path:::::

Solution Explorer : Models(Folder): Add : New Item : ADO.NET Entity Data Model : EF Designer From Database : New Connection

Now here in "New Connection" I want to connect my postgresql database using Postgresql Datasource but I have only SQL Server datasource option there, Anybody know how to deal with this ERROR..??

Note: I have added Npgsql, entityframework5.Npgsql through NuGet.

ALTER  PROCEDURE [dbo].[usp_Update_Service_Program_Detail] 
    @PK_Service_Program_County_RateCap_Detail int,
    @Unit_Type int,
    @Rate_Cap decimal(15,2),
    ----@County int,
    @ModifiedBy nvarchar(50),<br />
    @ModifiedOn datetime=getdate
AS
BEGIN 

select '220' 'Col' -- Test statement
    --Logic is here         
END  

exec usp_Update_Service_Program_Detail @PK_Service_Program_County_RateCap_Detail= 53196434
, @Unit_Type=1
, @Rate_Cap=100
, @ModifiedBy='aaleemmo'
, @ModifiedOn=getdate

Error converting data type nvarchar to datetime at @ModifiedOn=getdate