Missing “Ado.Net Entity Data Model” on Visual Studio 2013
Go to “C:\ProgramData\Package Cache” and search for “EFTools.msi”. You should find two files, just install the most recent one (it should be about 960KB). This fixed the problem for me.
ado.net
What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
When dealing with varbinary(max), there are two scenarios: the length of the data is moderate the length of the data is big GetBytes() is intended for the second scenario, when you are using CommandBehaviour.SequentialAccess to ensure that you are streaming the data, not buffering it. In particular, in this usage you would usually be writing … Read more
ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
Once I determined that it is the ADO.NET connection at the root of the problem, this thread led me to the answer. Basically connections through Sql Server Management Studio (SSMS) by default have SET ARITHABORT ON. ADO.NET connections do not. Setting ARITHABORT OFF and executing the query directly through SSMS gives me the same slow … Read more
Why does the SqlParameter name/value constructor treat 0 as null?
As stated in the documentation for that constructor: When you specify an Object in the value parameter, the SqlDbType is inferred from the Microsoft .NET Framework type of the Object. Use caution when you use this overload of the SqlParameter constructor to specify integer parameter values. Because this overload takes a value of type Object, … Read more
Reading a date using DataReader
Try as given below: while (MyReader.Read()) { TextBox1.Text = Convert.ToDateTime(MyReader[“DateField”]).ToString(“dd/MM/yyyy”); } in ToString() method you can change data format as per your requirement.
What is the difference between dataview and datatable?
When you want to run a query and show the subset of data in a control, a DataView could help you. That’s just one example, look at the MSDN example for DataView, that explains where you should use DataViews with DataTables… DataTable A datatable is an in-memory representation of a single database table. You can … Read more
How do I extract data from a DataTable?
The DataTable has a collection .Rows of DataRow elements. Each DataRow corresponds to one row in your database, and contains a collection of columns. In order to access a single value, do something like this: foreach(DataRow row in YourDataTable.Rows) { string name = row[“name”].ToString(); string description = row[“description”].ToString(); string icoFileName = row[“iconFile”].ToString(); string installScript = … Read more
Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
I did some testing and there does seem to be some buffering going on with ACE OleDb. I found that If I did some INSERTs and then immediately did a SELECT on the same OleDbConnection the new rows were available right away. If I opened two OleDbConnection objects, INSERTed on con1, and then immediately SELECTed … Read more
Entity Framework v2 doesn’t support sql 2000?
Submitted a support call to microsoft and they responded: Entity Framework v2 doesn’t support sql 2000 Here is there response: Thank you for posting this bug. Unfortunately, a business decision was made to no longer support SQL Server 2000 in this scenario. So no support for sql 2000 in entity framework v2 in .net 4.0
How to map Table per Type (TPT) inheritance in Entity designer?
Yes that is how Entity designer behaves. If you model your structure in the database and use Update model from database it will indeed be modeled as common associations beacuse EF doesn’t know yet that you want to model it as inheritance. You will get this: You must manually modify this model to use TPT … Read more