loopback 4 model options not working for mssql about loopback-connector-mssql HOT 5 CLOSED

@phiricharles101 , it should be something like:

@model({
  settings: {
    postgresql: {
      table: 'customer',
    },
  },
})
export class Customer2 extends Entity {

For details, please see details in this GitHub issue: loopbackio/loopback-next#2134, and continue discussion there.

from loopback-connector-mssql.

@dhmlau
Thank you so much,
I was also missing @loopback/repository-json-schema in the package.json

from loopback-connector-mssql.

Hi,

I am trying to connect to a mssql db and specify the table name. I have tried the below and still not working.

@model({
    name: 'VehicleModel',
        options: {
            mssql: {
                schema: 'dbo',
                table: 'Vehicles_VehicleRecord'
            }
        }

})
export class VehicleModel extends Entity {
	@property({
		type: 'number',
		id: true,
		required: true
	})
	id: number;

	@property({
		type: 'string',
		required: true
	})
	name: string;

	constructor(data?: Partial<VehicleModel>) {
		super(data);
	}
}

ERROR:

Invalid object name 'dbo.VehicleModel'.

from loopback-connector-mssql.

@phiricharles101 , is this issue good to close then? Thanks.

from loopback-connector-mssql.

Yes it is. Thanks

from loopback-connector-mssql.