6/30/2025 9:29:00 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Confusion about Saleslogix Web Platform
Posted: 24 May 10 11:09 AM
|
HI!
Apologies in advance if this is a silly question, but I've been unable to find the answer elsewhere.
My boss really wants me to use the provided framework to insert records into our SalesLogix database. I'm working in C#, and here is the example code I'm working off of: http://customerfx.com/pages/crmdeveloper/2009/01/29/programatically-adding-a-new-record-in-saleslogix-web.aspx
The problem is I'm trying to use this in a windows service. First off is this even possible to do? If the answer is no, great, I saw the article on generating new keys, I can just do that by hand.
However, if it is possible with some finagling, where do I start? All the applications/examples I've looked at have been web examples, which use connection.config. (So how do I establish a connection from a non-web application for a start?)
Thanks in advance - even a simple yes or no will help infinitely. 
(Also, would appreciate no 'why would you want to do that?' answers... I am a code monkey just doing what I'm asked to.  ) |
|
|
|
Re: Confusion about Saleslogix Web Platform
Posted: 24 May 10 11:31 AM
|
That article does not apply to your Code.
That article is for code written within the SLX Web client.
You mentioned that you are building a Windows service, so you need to use the SLX OLEDB Provider.
Basically, you use ADO.NET OleDb libraries as normal, and use the SLX OleDb Provider. Just build a connection string with the necessary connection infor and credentials and write your SQL queries.
|
|
|
|
Re: Confusion about Saleslogix Web Platform
Posted: 24 May 10 11:59 AM
|
Raul, thanks for the quick reply!
Well, that's just what I've been given as a resource... as I said, I don't have any resources that are not for the web.
I think what you are implying is that stuff like the following is only for web applications:
Sage.Entity.Interfaces.ILead lead = Sage.Platform.EntityFactory.Create();
//...assign the fields, etc
lead.Save();
Am I understanding correctly?
I'm currently using the OleDbConnection to generate new table keys, and thus am already using SLX OLEDB Provider in my project. I can certainly create commands to execute directly on the database, that's no problem. If this is the way to go, then great, problem solved. Main issue was that I was told to use the above code if possible to do so. |
|
|
|
Re: Confusion about Saleslogix Web Platform
Posted: 24 May 10 12:13 PM
|
Yes, that code is exclusively for use Internallyl within the SLX Portal.
If you are looking for alternate ways to read/write data into SLX, you could use the SData interfaces, but that may be a bit more work.
Otherwise, if you know the tables you are in need of writing data, just create your SQL Insert/Update statements and run them through the Provider. |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|