If you want to copy data selected by EF into an Excel workbook, look at this example:
Entity Model to Excel using LINQ in C#.
If you want to copy the table's field names and data types into a worksheet, you could probably use reflection to get that information from the table's class.
Or you could just open up the automatically-generated file that defines the class and look at its properties. For example, suppose you create a model named StudentModel and it has an entity named Student. Then in Solution Explorer, you would open StudentModel.edmx > StudentModel.tt > Student.
vb. It might look something like this:
Code:
Partial Public Class Student
Public Property StudentId As Integer
Public Property FirstName As String
Public Property LastName As String
Public Property NumUnits As Nullable(Of Integer)
End Class
Let me know if none of those options does what you want.
Export from entity context to excel
