In the past EF would blow up when trying to make an *.edmx file on a table with no PK. As of EF 6 (or at least 6.13) it allows them but the result set returned when performing a join on a table will this version can/will be incorrect.
A deadly, but silent, error.
Wednesday, January 6, 2016
SQL Server Finding the Object Alter Date
select TOP 1 * from sys.procedures order by create_date desc
select TOP 1 * from sys.tables order by create_date desc
select TOP 1 * from sys.views order by create_date desc
/*
CREATE PROC jkAlterProcTest
AS
SELECT 1
CREATE TABLE jkAlterTableTest (a int)
CREATE VIEW jkAlterViewTest
AS
SELECT a
FROM jkAlterTableTest
ALTER PROC jkAlterProcTest
AS
SELECT 2
ALTER TABLE jkAlterTableTest ADD b int
ALTER VIEW jkAlterViewTest
AS
SELECT a, b
FROM jkAlterTableTest
*/
select TOP 1 * from sys.tables order by create_date desc
select TOP 1 * from sys.views order by create_date desc
/*
CREATE PROC jkAlterProcTest
AS
SELECT 1
CREATE TABLE jkAlterTableTest (a int)
CREATE VIEW jkAlterViewTest
AS
SELECT a
FROM jkAlterTableTest
ALTER PROC jkAlterProcTest
AS
SELECT 2
ALTER TABLE jkAlterTableTest ADD b int
ALTER VIEW jkAlterViewTest
AS
SELECT a, b
FROM jkAlterTableTest
*/
Subscribe to:
Posts (Atom)