After several years of development, MBrace 1.0 was released last week. MBrace is a programming model for scalable cloud data scripting and programming with F# and C#. The project consists mainly of code libraries and cloud providers runtime.
Blazor Course - Use ASP.NET Core to Build Full-Stack C# Web Apps (8 Hours Full Course)
Rider 2021.1: Updates to Docker and C# Support, Scaffolding in ASP.NET, and More!
Create PROCEDURE Test1
AS
SELECT * FROM tblPIDs1
USE testdb
SET NOEXEC ON;
exec test1 ;
SET NOEXEC OFF;
USE testdb
SET FMTONLY ON;
exec test1 ;
SET FMTONLY OFF;
Msg 208, Level 16, State 1, Procedure test1, Line 3
Invalid object name 'tblPIDs1'.
USE testdb;
SET NOCOUNT ON;
DECLARE @name NVARCHAR(MAX),
@sql NVARCHAR(MAX),
@type CHAR(2), -- object type
@type_desc NVARCHAR(60), -- object type description
@params NVARCHAR(MAX) -- parameters
DECLARE @tblInvalid TABLE (
-- invalid objects
[type_desc] NVARCHAR(60),
[name] NVARCHAR(MAX),
[error_number] INT,
[error_message] NVARCHAR(MAX),
[type] CHAR(2)
);
DECLARE testSPs CURSOR FAST_FORWARD
FOR
SELECT [name] = OBJECT_NAME(SM.[object_id]),
[type] = SO.[type],
SO.[type_desc],
[params] = (
SELECT (
SELECT CONVERT(
XML,
(
SELECT STUFF(
(
SELECT ', ' + [name] +
'=NULL' AS
[text()]
FROM sys.parameters
WHERE [object_id] = SM.[object_id]
FOR XML PATH('')
),
1,
1,
''
)
)
)
FOR XML RAW,
TYPE
).value('/row[1]', 'varchar(max)')
)
FROM sys.sql_modules SM
JOIN sys.objects SO
ON SO.[object_id] = SM.[object_id]
WHERE SO.[is_ms_shipped] = 0
AND SO.[type] = 'P'
OPEN testSPs
FETCH NEXT FROM testSPs INTO @name, @type, @type_desc, @params
WHILE (@@FETCH_STATUS = 0)
BEGIN
BEGIN TRY
SET @sql = 'SET FMTONLY ON; exec ' + @name + ' ' + @params +
'; SET FMTONLY OFF;'
--PRINT @sql;
EXEC (@sql) ;
END TRY
BEGIN CATCH
PRINT @type_desc + ', ' + @name + ', Error: ' + CAST(ERROR_NUMBER() AS VARCHAR)
+ ', ' + ERROR_MESSAGE();
INSERT INTO @tblInvalid
SELECT @type_desc,
@name,
ERROR_NUMBER(),
ERROR_MESSAGE(),
@type
;
END CATCH
FETCH NEXT FROM testSPs INTO @name, @type, @type_desc, @params
END
CLOSE testSPs
DEALLOCATE testSPs
SELECT [type_desc],
[name],
[error_number],
[error_message]
FROM @tblInvalid
ORDER BY
CHARINDEX([type], ' U V PK UQ F TR FN TF P SQ '),
[name];
If Not a And b Then ... Else ... EndIf
if(!(a) && b)
{
...
}
else
{
} public interface ICommand
{
}
public class Command1 : ICommand
{
}
public class Command2 : ICommand
{
} ICommand command = new Command1();
if (!(command is Command2))
{
} if (command is not Command2)
{
} if ((command is ICommand) && !(command is Command2))
{
} if (command is ICommand and not Command2)
{
} if (command is Command1 or Command2)
{
} var number = new Random().Next(1, 10);
if (number > 2 && number < 8)
{
} if (number is > 2 and < 8)
{
} public static bool IsLetterOrSeparator(char c) => (c >= 'a' && c <= 'z') || (c >= 'A' && c <= 'Z') || c == '.' || c == ',';
public static bool IsLetterOrSeparator(char c) => c is (>= 'a' and <= 'z') or (>= 'A' and <= 'Z') or '.' or ',';
var number = new Random().Next(1, 10);
if (number <= 0)
{
Console.WriteLine("Less than or equal to 0");
}
else if (number > 0 && number <= 10)
{
Console.WriteLine("More than 0 but less than or equal to 10");
}
else
{
Console.WriteLine("More than 10");
} // C#9.0
switch (number)
{
case <= 0:
Console.WriteLine("Less than or equal to 0");
break;
case > 0 and <= 10:
Console.WriteLine("More than 0 but less than or equal to 10");
break;
default:
Console.WriteLine("More than 10");
break;
} // C#7.0
switch (number)
{
case int value when value <= 0:
Console.WriteLine("Less than or equal to 0");
break;
case int value when value > 0 && value <= 10:
Console.WriteLine("More than 0 but less than or equal to 10");
break;
default:
Console.WriteLine("More than 10");
break;
} var message = number switch
{
<= 0 => "Less than or equal to 0",
> 0 and <= 10 => "More than 0 but less than or equal to 10",
_ => "More than 10"
}; private static int GetDiscount(Product p) => p switch
{
Food => 0, // Food _ => 0 before C# 9
Book b => 75, // Book b _ => 75 before C# 9
_ => 25
}; public delegate void Action<in T1, in T2>(T1 arg1, T2 arg2); public delegate TResult Func<in T1, in T2, out TResult>(T1 arg1, T2 arg2);
Func<(string firstName, string lastName), string> f = (data) => data.firstName + data.lastName;
f(("Foo", "Bar"));