data-access
Reading parts of large files from drive
I\'m working with large files in C# (can be up to 20%-40% of available memory) and I will only need small parts of the files to be loaded into memory at a time (like 1-2% of the file).I was thinking t[详细]
2023-02-14 21:47 分类:问答Fast SQL question about multiple month dates
SELECT DISTINCT MonthName(Month([Date])) AS [Month], tblSupportCalls.System, Count(tblSupportCalls.System) AS [Total for System], Year([Date]) AS [Year][详细]
2023-02-14 17:49 分类:问答How should we use ASP.NET Data Access Classes (Converting from ColdFusion)
We\'re converting from ColdFusion to ASP.NET 4.0 and we just don\'t know which route to take with setting up our classes.[详细]
2023-02-11 07:21 分类:问答What is the Best Way to Perform Geo Spatial Searches with Entity Framework Code First CTP 5?
I\'d really like to 开发者_开发知识库give Entity Framework 4 Code First CTP a try with a greenfield app but I want to make sure that geo spatial searches will not be a problem before I do, or I\'ll go[详细]
2023-02-09 12:54 分类:问答Modernising a 'Hand Rolled' Data Access Library
There\'s this web app, which relies on a sort of data access library (simple data objects and associated objects to perform CRUD operations on them) which is generateddirectly from the database.[详细]
2023-02-08 04:48 分类:问答Data Access Object or Inline Methods
I am still very new to Actionscript and have an okay working knowledge of Flex.I am working on an AIR application that runs a SQLite database underneath.The database is only 3 tables (projects, items[详细]
2023-02-07 08:55 分类:问答Thread was being aborted In WebService and ASPX page
I\'m having the Thread was being aborted exception in this simple code, running on IIS 6 when I run a long query.[详细]
2023-02-06 05:57 分类:问答Should Validation and Data Correction logic be done in business or data access layer?
So I have this general question of where should I have certain logic for example - var data=GetItems();[详细]
2023-02-04 17:55 分类:问答Where to define webservices as asynchronous?
I\'m working on a iOS project and I\'m asking myself a question for a couple of days. My problem is simple: I have webservice calls which are synchronous. But I would like to do asynchronous calls. Bu[详细]
2023-02-03 20:28 分类:问答When should I use a SQLTransaction
What is the appropriate time to use a SQLTransaction? I开发者_开发知识库 use them for all of my INSERT, UPDATE and DELETE statements.[详细]
2023-01-30 13:35 分类:问答