How can I do an in-memory SQL Server for integration testing?

I want to be able to create a database and tables the same way Amazon's DynamoDb client does it but with Sql Server. Is that possible?

I'm using .net Core and this is for integration tests. Figured I can throw in the code in the fixture.

Anyone have any ideas?