Will Merydith's Q&A profile

• Visual Studio 2008 (Pre-release) Feature Comparison With NHibernate

  I'm very interested in the new features to come in ADO.NET, particularly those that will support model based development. My question is whether anyone has done a feature comparison with ORM products like NHibernate and/or whether work has begun on figuring out what the "upgrade" path from such ORM products will be stored procedures and DB views looking as wrong way for current enterprise development: enterprise block from Microsoft considers independency from DataBase and most of other update systems too, so this is not looking as big advantage in general functionality, bur for those who want use SQL as logics (hard to maintain) and attach self to only one database It is for efficiency, not ...Show All

• SQL Server How to create cumulative S-curve?

  Hi I need to make two reports: one containing the Raleigh chart, the other containing a cumulative curve. In the raleigh report I do this: Per project I can see the amount of mandays on a timebase(weeks). For the s-curve (cumulative curve) this needs to happen (and I dont know how): I need to see the sum of the amount of mandays on a timebase(weeks). An example: In raleigh curve: week1 has 20md(mandays), week2 has 30md, week3 has 15md, week4 has 5md In s-curve the same values should give: week1 has 20md, week2 has 50md(30+20), week3 has 65md(50+15), week4 has 70md (65 + 5) I tried a sum of a sum but thats not allowed in RS Anyone who knows how to generate an s-curve (cumulative curve) ...Show All

• Visual Studio Team System Error while editing WorkspaceMapping.xml file to get sources from other TP

  Hi, I know that this Q was asked already on this forum But, I couldn't get really answer for this issue - Way can't I get sources from few team projects when I'm editing the WorkspaceMapping.xml file to get sources from a few team projects My WorkspaceMapping.xml looks like this: < xml version = " 1.0 " encoding = " utf-8 " > < SerializedWorkspace xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd = " http://www.w3.org/2001/XMLSchema " > < Mappings > < InternalMapping ServerItem = " $/TeamProject1 " LocalItem = " D:\Program Files\Microsoft Visual Studio 8\Common7\IDE " Type = " Map " /> ...Show All

• Visual Studio Express Editions Connecting to SQL Server not a Database file

  I have recently downloaded VB 2005 Express and have been developing an application in it. I have gotten to a point where I want to create a connection to SQL Server 2000. I am able to do this by writing out the code: Dim conn As New SqlConnection conn.ConnectionString = "server=SQL_Server;database=Web;Trusted_Connection=True" Dim adapter As SqlDataAdapter adapter = New SqlDataAdapter( "SELECT * FROM tblBedStatus" , conn) Dim dsBedStatus As New DataSet adapter.Fill(dsBedStatus) I am not able to create a connection to the SQL Server by using the "Add New Data Sources". The only Data Sources that I have listed are "Microsoft Access Data File" and "Microso ...Show All

• .NET Development Site License protection schemes, defeating Reflector?

  I am invovled in the development of a programmer tool written in asp.net 2.0. My company is interested in securing this tool via an encrypted license file. However, we realize that anyone using Reflector could easily crack our protection. One way around this would be to make extensive use of web services, but this is not an acceptable solution for us. Would using unmanaged code to perform some core functionality solve this problem The unmanaged could could check the encrypted license file and when decompiled, it would not be as insecure as decompiled managed code. Has anyone done this Is the theory sound Peter, Thanks for the link. The remotesoft product looks excellent; however, it is a bit ...Show All

• .NET Development adding Window Media Player into IE Toolbar

  Hello: I am facing a problem in adding a Window Media Player Control into IE ToolBar. I found a project written in C# on Code Project site that can add a text into IE toolBar. But I can't add the window Media Player into IE. The Project I found constitutes of 2 projects BandOjLib and SampleBars window Application C sharp where the development is happening in it. So what you do in SampleBars project will be embedded into BandObj Project after compilation and start without debugging both BandObj and SampleBars respectively. When I am adding the Window Media Player into TOOLBOX, then to drag it into window Form => it gives me this error: Assembly generation failed -- Referenced assembly 'AxInterop.WMPLib' does not hav ...Show All

• .NET Development Fatal Flaw in the Large Object Heap?

  Hi All, After playing with the GC I find the following interesting. The problem domain I typically work in requires the allocation of very large arrays for image processing. We have discovered some issues when our processes are long running. We run out of memory and can not reclaim it. Our only recouse is to restart our processes. In an effort to discover why I uncovered the following: The LOH (Large Object Heap) is never compacted. I think this is a fatal flaw in the GC. I understand MS stated reason for this, but shouldn't there be someway to compact the LOH if necessary, at least a method call that forces the issue Does anyone know of anything that can be done Any workaround is better than killing the process... Here is a demo ...Show All

• Windows Live Developer Forums Is there any way to fill a polyline?

  Does anybody have any ideas I'm looking at two approaches. Firstly, overlaying a png file over the map, and retrieving the graphic from a server. The advantage of this is that it's easier to write the drawing code on the server. A disadvantage is that it increases server load. Secondly, I'm looking to draw the polygons using SVG/VML depending on the browser. There's an open source library that will do this ( http://sourceforge.net/projects/excanvas ). This means writing code in Javascript which isn't as easy. ...Show All

• Visual Studio Team System TFSBuild & sourceControl Deposit

  Hi, I am currently working on a task that publish within the SourceControl the result of the libraries' LastBuild . This task aims to furnish to the developer the last version of their assemblies. I want that they intentionaly use the GetLatestVersion to get the builded assemblies. The task get a local Workspace defined on the app server , check out all the content of a folder named _assemblies. get the content of the lastBuild (within the dropZone ) and copy it straight to the workspace assemblies folder then pendEndit or PendAdd files and finally checkIn pending changes. The task work fine while I tested it with a simple test.proj executed on the server but once I add it to the AfterEndToEndIteration target I am faci ...Show All

• SQL Server How does Analysis Services treat Dual-core CPUs?

  Guys, Dual-core refers to a CPU that includes two complete execution core per physical processor. Basically it means that it combines 2 processors, their caches, cache controllers into single intergrated circuit.My network folks say that OS thinks of a 4 dual-core physical CPUs as basically 8 physical processors. However I want to know as to how Analysis Services treats a 4 dual-core processor machine. Does it treat it as a 4 processors or 8 processors From the perf mon, here is what I see from Analysis Services doing parallel processing of partitions. Processor counter -- %processor Time --------------------------------------------------------- _total = 16.211 CPU 0 = 51.563 CPU 1= 54.688 CPU 2= 0.001 CPU 3= 0.001 CPU 4= 0.001 ...Show All

• Commerce Server Tax Calculations

  I am looking for a sample pipeline Component to caculate tax. I don't need very advanced tax calculations just 3 states with a flat tax and all my products are taxable. Any assistance would be greatly appreciated. Hi there, while we don't have a tax component sample the SDK includes a sample pipeline component implementation. You can use this sample as a starting point in providing your tax calculation logic. At the very basic level, you would need to get the state code from a dictionary item that is passed into the pipeline component, and then run a branching logic to calculate the specific state tax. Hope this helps! Thanks, Caesar. ...Show All

• SQL Server Reading the msmdserv.log file in SSAS 2005

  I need to be able to access this log but when I try to open it with Notepad it appears to be in Unicode with a space between each letter. Is there a way of a) accessing the log from within BIDS or Mgt Studio and b) if not, how do I change the format so that it is a usable file Thanks! The same informantion you are seeing in the msmdsrv.log you should be able to see in the Windows event log. Just sort by the Source column and see all the events assosisated with MSSQLServerOLAPService. HTH Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights ...Show All

• SQL Server StrToMember performance issue

  I am building a parameterised report against a cube. After starting with an MDX statement that performed perfectly well and parameterising it the performance went downhill fast. I was able to replicate similar symptons against the Adventure Works cube. In this example I am getting sales values at 2 different dates and breaking them down by Sales Territory and Customer Geography dimensons. In fact they could be any dimensions, but I do need to add a crossjoin in order for the problem to show itself. WITH MEMBER Measures.FirstDateAmount as --([Date].[Date].&[32],[Measures].[Internet Sales Amount]) ( StrToMember ('[Date].[Date].&[32]'),[Measures].[Internet Sales Amount]) MEMBER Measures.SecondDateAmount as ([Dat ...Show All

• Windows Forms BindingSource.AddNew returning primary key from DB

  I am binding a DataGridView to a BindingSource as follows. myConnection = New SqlConnection(My.Settings.Default.ConnectionString) dset = New DataSet() Dim qry As String = "SELECT * FROM approvals" Try adapter.Fill(dset, "approvals") bsource.DataSource = dset.Tables("approvals") dgv.DataSource = bsource Catch ex As Exception MessageBox.Show(ex.Message) End Try The DGV behaves as normal, except when user adds a new row (either using the DGV or with bsource.AddNew() ) I need the primary key field to auto populate correctly as it does when the DGV is implemented using the "Drag 'n' Drop" method of databinding. When user adds a new row, the ...Show All

• SQL Server Using CTE in data paging

  I explore a possibility of using Common Table Expression (CTE) instead of temporary table in data paging. But the problem is that it looks like I can reference CTE only once in my script. I need to return data for a current page as well as the row count for entire selection. Here is my script: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_name, first_name), first_name, last_name from contacts where last_name like 's%' and first_name like 'm%' ) select row_num, first_name, last_name from names where row_num between 41 and 60 -- 3rd page order by row_num select count(*) from names go It selects 20 records, however it displays an error when it tries to execute select count(*): ...Show All