I am fairly new to entity framework, and i am planning to use it in my next project. what permissions should web give to the sql server user login which entity framework uses? since i read entity framework does DML operations do i need to provide datawriter role to login? ...
Hi, I've started the development of a windows application, which target windows 7 and vista (maybe XP). I wanted to have some standard behavior that we find in the default windows applications. But I can't find anything to do that, so I have some questions : 1) For example, on Windows 7, the address bar that displays the current folde...
As far as I know Windows Media Player 10 is the minimum requirement for WPF MediaElement to work. What is a decent way to programmatically (from .NET) check if WMP is present, and its version? ...
I'm trying to find an IOC container that will allow me to have mapping data for a field stored in a database and resolve the interface or object that needs resolved via a string value pulled from the database. Most of the examples I have seen are using interfaces hard coded in code, I want the interface that needs to be resolved to be ...
Hi folks, I've published an online-only ClickOnce-deployed application. It is linked from a web application. As the application has pre-requisities, I will need them to click on the link to the setup file and not the direct link to the application (am I correct?). However, I will need to pass URL parameters to the application. Is th...
I'm trying to get a setup package to run. If my application and it's setupproject is targeting x32 everything installs fine. But the application fails to load some COM+ components since they are 64bit. If I manually replace the application (after the setup have finished) with a 64bit version everything runs fine. When I change my app a...
This function is used to return a contact list for a users search input. The number of search terms is always at least one, but could be many. public IList<Contact> GetContacts(string[] searchTerms) { using (dbDataContext db = new dbDataContext()) { var contacts = from _contacts in db.Contacts orde...
I'm using .NET, and going crazy trying to find any helpful API that lets me transfer a file across a LAN network (trough admin credentials of course) and then execute it on that machine. I've read some thing using WMI, but googling for ".net WMI copy files" or ".net WMI execute files" isn't helping me at all. Any references would be gr...
Hi, all, I am trying to execute an insert command into the database and one of the columns is of type nvarchar(MAX). Insert command is created by using .NET SqlCommand class and each of the parameters is represented by one SqlParameter object. My command gets executed always, but when I pass string which length is large (10000+ charac...
Let's say I have a MySql stored procedure that inserts a record with some nullable CHAR fields. In VB.NET if I don't check for Nothing (or Null in other languages), I get an exception from the db driver, so I write: command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("_name", if(name Is Nothing, "", name)...
What would it be the simplest way to merge a result like this from a sql query to be displayed in an asp.net gridview? NULL Tarde Fer W. Lunes Mañana NULL Fer W. Lunes I need the result to look like this Mañana Tarde Fer W. Lunes ...
Dear Friends I would like to know that is it possible to Insert a batch of SqlCeCommand(s) ? note : All SqlCeCommand(s) have got a property. ( not solid sql command ) thank you; ...
I want to ignore all elements of Dictionary while serializing as those members cause an exception example class: public class TestClass{ public string StringTest { get; set; } public int IntTest { get; set; } public Dictionary<int, string> someDictionary { get; set; } } What i tried(unsuccessfull) XmlAttributeOverrides x...
I have a domain service, derived from LinqToEntitiesDomainService<FOOEntities> It has one method, IQueryable<Bar> GetBar(). GetBar returns a LINQ query on the entity model. The LINQ works fine in LINQPad. In the XAML of a Silverlight thingy, I have a ListBox whose ItemsSource points to a DomainDataSource defined in the same XAML file,...
Hi, I want to make transactional a series of sp call (sql server 2005) in a .net 2.0 project surrounding some piece of business logic with a using(TransactionScope...) Unluckily, I inherited the DAL from another project and I don't want to make many changes there..the problem is that every method that calls a stored procedure opens...
I've written compiled queries for my ObjectContext which I use as select methods in a ObjectDataSource. The proble is that I now want to implement sorting and paging and I'd like to it in data layer which means I need to add .OrderBy and .Take/.Skip to my compiled queries. Does this make sense? I mean won't the compiled query recompile e...
I have a class library I want to unit test using Microsofts unit test framework. Some of the classes I want to test are configured using application settings. These settings are defined inside the Settings.settings file having application scope and suitable default values. When the library is used by the application these settings can be...
I am new to both MVC as well as Entity Framework, but I want to do my next project using those technologies. I went through the NerdDinner tutorial at http://nerddinnerbook.s3.amazonaws.com/Part1.htm. NerdDinner uses Linq to Sql and uses the Repository pattern to manage data access. NerdDinner is written so well that I wanted to use it...
Hi, I need the ability to sort a collection of customers which contains a property of numeric string. How Can I sort the below collection by code in numeric order. Again Code is a string. class Program { static void Main(string[] args) { SortableObservableCollection<Cus...
Hi, We have a .NET application that is loading a java applet through the IE control. the problem started when we upgraded our server to 64 bit (window xp) and using JRE version to use 1.6-18. Since then, the applet is stop loading when it using the JRE 1.6 . I also tested it to see if it was running under 32 bit IE running on a 64 bit...