giacomelli · May 31, 2021 11:07
diff --git a/change-template.cs b/change-template.cs
 var projectNamespace = "Sample.Data";
diff --git a/cte.sql b/cte.sql
 --<cte>
 WITH LastMessages(ContactId, Id, NotRead)
 AS (	
 )
 --</cte>
diff --git a/install-package.sh b/install-package.sh
 install-package SqlAsFile
diff --git a/test-args.sql b/test-args.sql
 --<test-args>
 DECLARE @name VARCHAR(100) = 'test';
 DECLARE @surname VARCHAR(200) = NULL;
 --</test-args>
diff --git a/usage.cs b/usage.cs
 // Using the SQL inside of the file SampleSql2.sql on the folder 
 // SampleData\Data\SampleNamespace1\SampleSubNamespace1.
 using SampleData.Data.SampleNamespace1.SampleSubNamespace1;
 ...
 var rows = connection.Query(Sql.SampleSql2).AsList();
	--<cte>
	WITH LastMessages(ContactId, Id, NotRead)
	AS (
	)
	--</cte>
	--<test-args>
	DECLARE @name VARCHAR(100) = 'test';
	DECLARE @surname VARCHAR(200) = NULL;
	--</test-args>
	// Using the SQL inside of the file SampleSql2.sql on the folder
	// SampleData\Data\SampleNamespace1\SampleSubNamespace1.
	using SampleData.Data.SampleNamespace1.SampleSubNamespace1;
	...
	var rows = connection.Query(Sql.SampleSql2).AsList();