Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
More EF Perplexities
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Entity Framework
Title:
More EF Perplexities
Environment versions
Environment:
C# 5.0
OS:
Windows 10
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01646576
Message ID:
01646576
Views:
32
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.
Next
Reply
Map
View

Click here to load this message in the networking platform