SQLTeam.com | Weblogs | Forums

Sql server 2016 memory optimized tables insert problem

Hi Team,

Need help on. In sql server 2016 created one memory optimized table. If we perform inserts manually ( from database side) data is getting inserting and able to view the data when we select. But If we insert into memory optimized table from C# code not able to view the data in new inmemory table. Please help on how to solve this issue.

Fire a extended event session or profiler to see what is sending the application.(the exact code)
Also take a look at your error log maybe something there

If I add some inserts before and after the insert of memory optimized table insert then I am able to see the data in those diskbased tables. No errors captured in log.