I want to get a size of Entity Class - which is fetched from database using Repository.
How to do so using Vb.net ?
Below Line is calling GetEntity Method which is in my InwardService.
Dim Inward As ARI.PurchaseTranEntity.InwardOutward = _InwardService.GetEntity(id)
So what i want to get the size is of
Inward ?
My Service Code For GetEntity Function is as Follows -
Public Overrides Function GetEntity(code As Integer) As ARI.PurchaseTranEntity.InwardOutward
Try
Dim Data = Repository.Query(
Function(c) c.Code = code).
Include(Function(c) c.InwardOutwardDetails).
Include(Function(c) c.AdditionalChargesDetails).
Include(Function(c) c.AdditionalChargesDetails.Select(Function(k) k.AdditionalChargesAccount)).
Include(Function(c) c.NoteDetails).
Include(Function(c) c.AttributeValues).
Include(Function(c) c.BusinessPartner).
Include(Function(c) c.Currency).
Include(Function(c) c.Buyer).
Include(Function(c) c.BillToAddress).
Include(Function(c) c.ShipToAddress).
Include(Function(c) c.Shipper).
Include(Function(c) c.PriceList).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.ProductTaggingDetails)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.ProductTaggingDetails.Select(Function(y) y.Product))).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.UOM)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.Item).Select(Function(d) d.ItemBarCodeLinks)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.Item)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.StockPoint)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.Tax)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.Buyer)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.InwardOutwardAllocationDetails)).
Include(Function(c) c.InwardOutwardDetails.Select(Function(x) x.RequisitionFulfillmentDetails)).
Select(Function(c) c).SingleOrDefault()
Catch ex As Exception
Throw ex
End Try
End Function
What I have tried:
So far by researching i got to know that , i can achieve it using SQL Query -
SELECT *
INTO dbo.MyTempTable
FROM stmItem
exec sp_spaceused 'Table'
DROP TABLE Table
Above Query is returning required Output -
name rows reserved data index_size unused
Table 8978 1296 KB 1264 KB 8 KB 24 KB
But i want 1264 KB using Repository Pattern. Any help would be appreciated ?