SELECT rows as Count FROM sysindexes WHERE id = OBJECT_ID('[EntityCollection]') AND indid < 2

In bulk logged recovery model, the bulk transactions are minimally logged it't not that they are not logged at all. It only records what extents have changed. So, when the...