Hello, If, in Database A, there exists a table named "MyTable" that actually comes from a synonym pointing to another database (B), can I create this table as an entity in an Entity Framework model that represents database A, since it actually resides in a different database? I'm curious if the situation with EF 4 has improved since th...
I've got a library which has two input formats for the object model described by the library. I currently use an event subscription model for raising errors/warnings/verbose messages to the end user of the library. This hasn't proven to be the cleanest model, and I was wondering if there was a relevant design pattern or something similar...
I recently posted (and promptly deleted, when I decided the question was irrelevant to the actual problem) a question about SqlConnection losing its Database information when the scope of "ChangeDatabase" ends. Example: //Other code... dbConn = new SqlConnection(dbConnBuilder.ConnectionString); dbConn.Open(); dbConn.Cha...
Problem I'm trying to get a list of print queues available on a remote server. Ultimately this will need to be performed from ASP.NET, but for now I'd settle for a console application to work. When I create an instance of the System.Printing.PrintServer class using the path to a remote server I am able to get basic information about...
I have created a small class library using .net 3.5 which builds a DLL that I want to use in an Access 2003 database. I have checked the Register for COM interop in the Compile options. Once the Build is done, there is dll and tlb file created. I now reference the TLB file in my access database and it works with no issues when it is ...
I am trying to incorporate an ajax autocomplete/autosuggest control into my website and am coming across all kids of issues. I tried the ajaxcontroltoolkit but ran into a deadend there. I would prefer not to get into jquery being I'm feeling overwhelmed enough as it is. I found this one http://www.codeproject.com/KB/custom-controls/Au...
I currently have a project I'm working on that has a target of .NET Framework 3.5. I am using Visual Studio 2010; however my coworkers use Visual Studio 2008. I am able to use C# 4.0 features such as optional function parameters, but if they try to build the same code with the same target, they are unable to. It was my understanding that...
Trying to troubleshoot a questionable plugin a client is experiencing issues with in production, and one possible issue I see is the fact that they're sending SMTP synchronously from within our heavily-transacted C# web application. In the past I believe I've read or been told that sending SMTP synchronously from within a transaction is ...
I have a to create an application using C# for the Windows Platform. Normally all of the work I've done was on a single machine: It had Visual Studio 2010, Microsoft SQL Server and a range of other tools. If I use Entity Framework for example, I know it'll work because I have a SQL engine installed. Here comes my problem and the point...
I am using .NET 2.0 with PlatformTarget x64 and x86. I am giving Math.Exp the same input number, and it returns different results in either platform. MSDN says you can't rely on a literal/parsed Double to represent the same number between platforms, but I think my use of Int64BitsToDouble below avoids this problem and guarantees the sa...
I have a class in a WCF service, lets call it A. A is a data contract, which contains as one of its DataMembers a collection of another custom object B. To avoid Null Reference problems on the client side, I instantiate the BList in the constructor like so: [DataContract] public class A { [DataMember] public String name { get; s...
Hello I'm hoping this will be relatively easy to someone who is familiar with the Google Calendar API, have done some searching but the API isn't giving me the answer! Imagine that a Google Account has 3 calendars, all created by that user. I'm trying to get events from a SPECIFIC calendar of that user, using the .NET Google API, as f...
If I have a variable, X, of type SqlDecimal, that was instantiated without providing a decimal value parameter to the constructor, then the .IsNull property is True: Dim X As New SqlDecimal '.Value = Null If I have a Stored Procedure that acepts a single parameter, @SqlDecimalParameter, of type Decimal, the value of this this paramete...
I'm using pre and post build events of my service to uninstall and install the service. The only problem is that the first time another developer uses the pre build event it fails since the service is not yet installed. My current pre build event which uninstalls is %WinDir%\Microsoft.NET\Framework\v4.0.30319\InstallUtil /u $(TargetPa...
This is purely a conceptual and design idea related to EF4. The example/scenario is a large ERP or CRM type system where companies may need to add traditional "user defined fields" to capture additional data. I know that the EF has some capabilities to push out the model to a database at run-time but the question really is can you use ...
Hey Guys and Gals, I have what I consider a bit of a tricky question. I am currently working on quite a large spread sheet (266 rows aith 70 coloumns and its only going to get bigger) that is a database of sorts and I want to remove it from Excel and put it on to an intranet page. I am currently writing it in a combination of HTML and ...
I'm working on an app that works with databases. Whenever I create more than one data table in my app, then erase one, and then try to close the app, it won't close. I added an event handler to the FormClosing event, and the Cancel property of FormClosingEventArgs is true. How can I track where is this property being set to true? ...
I am working with this XSD file. The portion of the XML that is relevant to this question is here: <?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="https://wsmrc2vger.wsmr.army.mil/rcc/manuals/106-11" targetNamespace="https://wsmrc2vger.wsmr.army.mil/rcc/manuals/106-11" ...
Hi, I have a excel sheet contains three columns Name, Email ID and Contact No. I would like to read data from a excel data and check through my code that the Email ID column contains @ sign, Contact No should be of maximum 10 digits, I would like to do these types of validation. Please suggest. ...
I am working on an application that has a large set of configuration values, modelled and organized through the .NET configuration types from the System.Configuration namespace (i.e. ConfigurationSection, ConfigurationProperty, ConfigurationElement, etc...). Several values are required and may or may not have defaults, while others are ...