public IList<AdvertismentViewModel> GetAdvertisementsByMe(int userId)
{
var adsList = _advertisements.Where(x => x.UserId == userId).ToList();
var adsViewModel = new List<AdvertismentViewModel>();
_mappingEngine.Map(source: adsList, destination: adsViewModel);
return adsViewModel;
} public class AdvertismentViewModel
{
public string Image { get; set; }
public string Title { get; set; }
public string ExpireDate { get; set; }
} Missing type map configuration or unsupported mapping. Mapping types: Advertisement -> AdvertismentViewModel Project.DomainClasses.Advertisement -> Project.Models.AdvertismentViewModel Destination path: List`1[0] Source value: System.Data.Entity.DynamicProxies.Advertisement_E82DFF273E08C95AA785F8F7A0D2B5ABC8E54C4566DFE1C8A92D8D3C447608AE
C:\>"C:\Program Files\Microsoft SQL Server\140\Tools\Binn\SqlLocalDB.exe" i MSSQLLocalDB ProjectsV13 v12.0 C:\>"C:\Program Files\Microsoft SQL Server\140\Tools\Binn\SqlLocalDB.exe" s MSSQLLocalDB LocalDB instance "MSSQLLocalDB" started.
// does not work: services.AddScoped<IGenericRepository<T>,EFRepository<T>>();
public void ConfigureServices(IServiceCollection services)
{
services.AddScoped<IStore<User>, SqlStore<User>>();
services.AddScoped<IStore<Invoice>, SqlStore<Invoice>>();
services.AddScoped<IStore<Payment>, SqlStore<Payment>>();
// ...
} public void ConfigureServices(IServiceCollection services)
{
services.AddScoped(typeof(IStore<>), typeof(SqlStore<>));
} services.Scan(scan => scan
.FromAssemblyOf<CombinedService>()
.AddClasses(x=> x.AssignableTo(typeof(IOpenGeneric<>))) // Can close generic types
.AsMatchingInterface()) services.AddTransient<IOrderHandler, OrderHandlerLazy>();
services.AddTransient<IAccounting, Accounting>()
.AddTransient(serviceProvider => new Lazy<IAccounting>(() => serviceProvider.GetRequiredService<IAccounting>()));
services.AddTransient<ISales, Sales>()
.AddTransient(serviceProvider => new Lazy<ISales>(() => serviceProvider.GetRequiredService<ISales>())); services.AddTransient(typeof(Lazy<>), typeof(LazyFactory<>));
public class LazyFactory<T> : Lazy<T> where T : class
{
public LazyFactory(IServiceProvider provider)
: base(() => provider.GetRequiredService<T>())
{
}
} 
{
"version": "0.2.0",
"configurations": [
{
"type": "chrome",
"request": "launch",
"name": "Launch Chrome with ng serve",
"url": "http://localhost:4200/#",
"webRoot": "${workspaceRoot}"
}
]
} {
"version": "0.2.0",
"configurations": [
{
"type": "chrome",
"request": "launch",
"name": "Launch Chrome for dotnet build & ng build",
"url": "http://localhost:5000/#",
"webRoot": "${workspaceRoot}"
}
]
} ngOnInit() {
this.formPoster.getLanguages().subscribe(
data => {
this.languages = data;
},
err => console.log("get error: ", err)
);
} >npm install >ng build --watch
>dotnet restore >dotnet watch run
{
"version": "0.2.0",
"configurations": [
{
"type": "chrome",
"request": "launch",
"name": "Launch Chrome for dotnet build & ng build",
"url": "http://localhost:5000",
"runtimeArgs": [
"--user-data-dir",
"--remote-debugging-port=9222",
"--disable-session-crashed-bubble"
],
"sourceMaps": true,
"trace": true,
"webRoot": "${workspaceRoot}/wwwroot/",
"userDataDir": "${workspaceRoot}/.vscode/chrome"
}
]
} 
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];
docker run --rm -it -p 8080:80 -v c:\users\vahid\mysite:/usr/share/nginx/html nginx
docker run -d -p 8080:80 --name nginx nginx
docker exec -it nginx bash
cd /usr/share/nginx/html
ls mv index.html index2.html exit
docker cp c:\users\vahid\mysite nginx:/usr/share/nginx/html
docker exec nginx ls /usr/share/nginx/html
docker commit nginx mysite:nginx
docker run -d -p 8090:80 --name mysite mysite:nginx
docker exec mysite ls /usr/share/nginx/html
docker run -d -p 8080:80 --name nginx nginx docker cp c:\users\vahid\mysite nginx:/usr/share/nginx/html docker commit nginx mysite:nginx
FROM nginx
COPY mysite /usr/share/nginx/html
docker build -f Dockerfile -t mysite:nginx-df .
docker build -t mysite:nginx-df .
FROM microsoft/iis:nanoserver COPY mysite c:/inetpub/wwwroot
docker build -t mysite:iis .
docker tag mysite:nginx-df my_user_name/some_name:new_tag_name
docker push my_user_name/some_name:new_tag_name
Bash Scripting on Linux
The Bash Scripting Essentials series will teach you everything you need to know in order to write effective bash scripts in Linux. The series starts with some introductory concepts, with each episode building on the last. By the end of this series, you'll be able to write your own bash scripts! The Bash Scripting series was one of the very first tutorial series on Learn Linux TV ever, so it's basically where it all started. Now, it's been remade and brought into the modern age. The new version of this series covers everything the original version did, with additional concepts added throughout.
