CREATE TABLE [dbo].[ToolLocation]

(

    [ToolLocation_nbr] SMALLINT IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [LocationName] NVARCHAR(20) NOT NULL,

    [Description] NVARCHAR(50) NULL,

    [IsActive] BIT NOT NULL DEFAULT(1)

)

GO

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Insus.NET.Models

{

    public class ToolLocation

    {

        public short ToolLocation_nbr { get; set; } = ;

        public string LocationName { get; set; } = string.Empty;

        public string Description { get; set; } = string.Empty;

        public bool IsActive { get; set; } = true;

    }

}

using Insus.NET.Models;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Insus.NET.Entities

{

    public class ToolLocationEntity

    {

        public IEnumerable<ToolLocation> ToolLocations()

        {

            return new List<ToolLocation>() {

                new ToolLocation(),

                new ToolLocation { ToolLocation_nbr = , LocationName = "A2", Description = "A2 CNC",IsActive = true},

                new ToolLocation { ToolLocation_nbr = , LocationName = "C4", Description = "C4 CNC",IsActive = false}

            };

        }

    }

}