You cannot “dynamically” add a column to a table per row. If the user could add a column, then that column would be added to the table in general, and every row in that table would have it. Even if this was possible, it would require granting your application admin rights on your database, which … Read more
I don’t use SQL Express very often, but it looks like your connection string is not right. In your screenshot 1 it shows DESKTOP-VN2SRQQ\SQLEXPRESS as your SQL server\instance. In screenshot 2 you have chosen (localdb)\mssqllocaldb as the server\instance. Try changing the server to DESKTOP-VN2SRQQ\SQLEXPRESS 0 solved I didn’t found the database in Entity Data Model … Read more
I found a nice turn around . If you try MemberwiseClone() to get a copy of the object and then add the object to the context and SaveChanges() you will get an error because the MemberwiseClone() does clone the Dynamic Proxy too . So my turn around is Create a new Context just for the … Read more
Try joining like this: select * from member a join friend b on a.id=b.userid 9 solved How connect 2 SQL Server tables with a query and use data dynamically