How to make .net's linq2sql friends with storages that return different types of tables

Question

SQL

There are storages of the form: Which, depending on the input parameters, return different tables. In fact, these are wrappers for working with data. But linq can't determine the return type itself. I would like to point it out to him. Is that possible?


IF @AccessEnabled = 1
BEGIN
IF @StartDate is null
SET @StartDate = '01/01/1900'
IF @EndDate is null
SET @EndDate = GETDATE()
IF @ReportType is null
SET @ReportType = 1

IF @ReportType = 1
BEGIN



Answer 1

How do you imagine using it?
what would it then return System.Object and after that you checked, and what parameters were passed and what object was obtained based on this?
You don't feel like you're on the wrong path.
And on the merits of the question, I will say the following: the designer has limitations and with dynamic queries, complex storage - it works, this is a limitation that cannot be managed with simple methods. but you always have the opportunity to tweak everything manually in .designer.cs to explicitly specify the data type.
but, again, at the slightest attempt to use the designer, the code will be returned to its original state and corrections will have to be made again.
but... and here there are games with partial fnctions

Answer 2

Sorry, the iPad is dumb.
I wanted to say: DOES NOT WORK with complex stored procedures

Answer 3

As for LINQ itself, here is the link.
http://professorweb.ru/my/LINQ/base/level1/info_linq.php