Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
More EF Perplexities
Message
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Entity Framework
Titre:
More EF Perplexities
Versions des environnements
Environment:
C# 5.0
OS:
Windows 10
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01646576
Message ID:
01646576
Vues:
33
Must have missed something:


I have this test routine :
       public static void Test_EXP_0071TAttached()
        {
            using (var context = new PluczExp_PluczContext(Config.model.SqlServer))
            {
                var sql = "dbo.Exp_0071TAttached";
                var attached = context.Database.SqlQuery<string>(sql).ToString();
                Console.WriteLine($"EXP_0071TAttached returns {attached}");
            }
        }
... that returns :" EXP_0071TAttached returns dbo.Exp_0071TAttached."

Here's the scalar returning function :
USE [Exp_Plucz]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[Exp_0071TAttached]()
RETURNS int
AS
begin
	declare @result bit = 0
	select @result = CAST(
		CASE WHEN DB_Id('EXP_0071T') is not null THEN 1
		ELSE 0
		END
	AS BIT)
	RETURN @RESULT 
END

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform