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
Source Code

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; } = 1;

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

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

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

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 = 2, LocationName = "A2", Description = "A2 CNC",IsActive = true},
    new ToolLocation { ToolLocation_nbr = 3, LocationName = "C4", Description = "C4 CNC",IsActive = false}
   };
  }
 }
}
Source Code