Skip to content

Instantly share code, notes, and snippets.

@giacomelli
Last active May 31, 2021 11:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save giacomelli/4dda230a09941b6300468a71ee3812ab to your computer and use it in GitHub Desktop.
Save giacomelli/4dda230a09941b6300468a71ee3812ab to your computer and use it in GitHub Desktop.
var projectNamespace = "Sample.Data";
--<cte>
WITH LastMessages(ContactId, Id, NotRead)
AS (
)
--</cte>
install-package SqlAsFile
--<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();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment