Exchange servers : webmail
file servers : file repositories
web servers : web application and sites
database servers : used to house databases such as Oracle, MS SQL Server
but one server (computer, machine, virtual machine) can serve as any and many of those
pod
Last Activity: Apr 19 '17, 04:02 PM
Joined: Sep 20 '07
Location: Canada's National Capital
-
MVC 5 C# Entities modelBuilder with multiple tables
Hello
I am trying to get the modelBuilder.En tity to link three tables: [Committees], [Members] and [Roles]
Table [LNK_Member_Comm ittee_Role] is where members are assigned a certain role within a certain committee; it contains the primary keys from the three tables in question.
Using the modelBuilder.En tity<Committee> code below, I am able to build entities that collects all the members assigned to... -
yeah, I just looked a little more into WCFServices and the control seems to be somewhat limited over the output format, it is a bit more complicated than I thought, I need more experience since I will need to get some ready soon for my own purposes. Although I did try one tutorial, a MVC Web API and the output is very flexible; can be JSON upon request from a web page and XML by default...
It may be not what you are looking for but I...Leave a comment:
-
Look into regular expressionsLeave a comment:
-
my solution
Thank you PsychoCoder for your reply... but that is not what exactly what I needed, I wanted the SUM of individual cases, and I figured out a way to do it ... I decided to do it outside the query
...Code:var myList = db.Electors. Where(x => x.VotedStrikeList == true || x.VotedPollBook == trueLeave a comment:
-
Lambda with SUM+Conditional
I am trying to convert an SQL statement into a LAMBDA expression. I have a basic understanding, I know how to write simple statements c/w filter portion(WHERE) but could not find anything on how to add conditionals into the SELECT portion.
Right now I query without the conditional part but the web server must loop through millions of returned records to do the calculation where I would prefer the SQL server to perform this on the first... -
Knock, knock Neo ... did you follow the white rabbit? :)Leave a comment:
-
Leave a comment:
-
Zed, it looks fine, the logic is what counts anyway...
Wrap it up
Thank youLeave a comment:
-
Funny, I must have watched Blazzing Saddles over 50 times when I was younger but I did not remember it was in it ... I've heard, Ella's version but not Cole Porter. MASH's Colonel Potter also says that line in the episode where Winchester gets his back pain cured by acupuncture performed by three visiting buddhist doctors refered as Larry, Curly and Moe ... a classic :)Leave a comment:
-
Yes you may "do that voodoo that you do so well"
Can someone tell me where I stole this quote ?
P:oDLeave a comment:
-
Although a lot of syntax is the same, there are many changes you will have to do. I presume you have a .NET Solutions with a Project that contains a Windows Form. I suggest you take the n-tier architecture approach (also described as multitier), creating objects and separating your data layer from your presentation layer, both as different projects.
Now as for your form connecting to the database, read this article I wrote Connecting...Leave a comment:
-
Bonjour NeoPa
Yes, I think it would be nicer to have better comments right at the top.
Thanks
P:oDLeave a comment:
-
Leave a comment:
-
char[] arr = "Hello World".ToCharAr ray;Leave a comment:
-
You "addData" function should return a stringMessage
Before adding any new records,
your data layer script should perform a search for existing data.
...Code:search for existing data If a match is found then no data will be inserted return a message saying "unable to add, data already exist" else insert the data return a message insertion
Leave a comment:
-
It took a while but there it is with slightly better comments...
If one of the moderators want to put this at the top, you have my blessing :)
P:oD
...Code:Public Function opendb() As ADODB.Connection ' This function returns an ADODB.Connection object ' which is required for accessing different types of databases ' ' Her we declare three stringsLeave a comment:
-
Pseudo code... up to you to make it work in C#
P:oD
...Code:splitString(myOriginalString) function{ myNewString = String.Empty myNewStringArray() lineArray()= myOriginalString.Split(linebreak) For arrayItem = 0 To lineArrayItemCount (probably - 1) If arrayItem Mod 15 = 0 Then myNewString = myNewString & "~" & lineArray(itm) ElseLeave a comment:
-
Found one post that explains it in simple terms Scott's Blog (some posts are so confusing)
Although the Match and Replace do not work exactly as they say, they at least works at the parent level:
I wanted to replace only one connection string but it replaces all strings but without touching the other configurations. .. good enough for me
Thank you all, I hope this helps someone else out there
...Leave a comment:
-
:) That is exactly what I started to use after posting my question, and it's working very well except for one section: the SqlProfileProvi der in web.config requires to know which connections string to use.
But, I just found out that the web.config can have some sub scripts: web.release.con fig and web.debug.confi g... I am reading up on it right nowLeave a comment:
No activity results to display
Leave a comment: