Start from scratch with SQL Server

1. Create a project directory and navigate into it:

   $mkdir hello-prisma
   $cd hello-prisma

2. Initialize a TypeScript project and add the Prisma CLI as a development dependency:

   $npm init -y
   $npm install prisma typescript ts-node @types/node --save-dev

This creates a package.json with an initial setup for your TypeScript app.

1. Next, create a tsconfig.json file and add the following configuration to it:

tsconfig.json
1{
2  "compilerOptions": {
3    "sourceMap": true,
4    "outDir": "dist",
5    "strict": true,
6    "lib": ["esnext"],
7    "esModuleInterop": true
8  }
9}

1. Invoke the Prisma CLI by prefixing it with npx - confirm that you can see the Prisma help screen:

$npx prisma

1. Set up your Prisma project by creating your Prisma schema file with the following command:

   $npx prisma init

This command created a new directory called prisma with the following contents:

 `schema.prisma`: The Prisma schema with your database connection and the Prisma Client generator
 `.env`: A [dotenv](https://github.com/motdotla/dotenv) file for defining environment variables (used for your database connection)

1. Create a project directory and navigate into it:

   $mkdir hello-prisma
   $cd hello-prisma

2. Initialize a Node.js project and add the Prisma CLI as a development dependency:

   $npm init -y
   $npm install prisma --save-dev

This creates a package.json with an initial setup for a Node.js app.

1. Invoke the Prisma CLI by prefixing it with npx - confirm that you can see the Prisma help screen:

$npx prisma

1. Set up your Prisma project by creating your Prisma schema file with the following command:

   $npx prisma init

This command created a new directory called prisma with the following contents:

 `schema.prisma`: The Prisma schema with your database connection and the Prisma Client generator
 `.env`: A [dotenv](https://github.com/motdotla/dotenv) file for defining environment variables (used for your database connection)

1. Create a file named index.ts and add the following sample code:

   import { PrismaClient } from '@prisma/client'
   
   const prisma = new PrismaClient()
   
   async function main() {
     // Create a user and two posts
     const createUser = await prisma.user.create({
       data: {
         name: 'Alice',
         email: 'alice@prisma.io',
         posts: {
           create: [
             { title: 'My first day at Prisma' },
             {
               title: 'How to create an Microsoft SQL Server database',
               content: 'A tutorial in progress!',
             },
           ],
         },
       },
     })
   
     // Return all posts
     const getPosts = await prisma.post.findMany({})
   
     console.log(getPosts)
   }
   
   main()
     .catch(e => {
       throw e
     })
     .finally(async () => {
       await prisma.$disconnect()
     })

2. Run the code with the following command:

$npx ts-node index.ts

You should see the following output:

[
  {
    id: 1,
    title: 'My first day at Prisma',
    createdAt: 2020-10-26T08:24:10.966Z,
    content: null,
    published: false,
    authorId: 1
  {
    id: 2,
    title: 'How to create an Microsoft SQL Server database',
    createdAt: 2020-10-26T08:24:10.966Z,
    content: 'A tutorial in progress!',
    published: false,
    authorId: 1
  }
]

1. Change email: "alice@prisma.io" to another email address and run the code again to create another user and list of posts.

1. Create a file named index.js and add the following sample code:

   const { PrismaClient } = require('@prisma/client')
   
   const prisma = new PrismaClient()
   
   async function main() {
     // Create a user and two posts
     const createUser = await prisma.user.create({
       data: {
         name: 'Alice',
         email: 'alice@prisma.io',
         posts: {
           create: [
             { title: 'My first day at Prisma' },
             {
               title: 'How to create an Microsoft SQL Server database',
               content: 'A tutorial in progress!',
             },
           ],
         },
       },
     })
   
     // Return all posts
     const getPosts = await prisma.post.findMany({})
   
     console.log(getPosts)
   }
   
   main()
     .catch(e => {
       throw e
     })
     .finally(async () => {
       await prisma.$disconnect()
     })

2. Run the code with the following command:

$node index.js

You should see the following output:

[
  {
    id: 1,
    title: 'My first day at Prisma',
    createdAt: 2020-10-26T08:24:10.966Z,
    content: null,
    published: false,
    authorId: 1
  {
    id: 2,
    title: 'How to create an Microsoft SQL Server database',
    createdAt: 2020-10-26T08:24:10.966Z,
    content: 'A tutorial in progress!',
    published: false,
    authorId: 1
  }
]

1. Change email: "alice@prisma.io" to another email address and run the code again to create another user and list of posts.